Setting "save as" and "save"

[Jess]

"I have an access application which generates an excel sheet; excel is
launched from access. I would like to implement the following behavior.

Whenever my user clicks “save†or “save as†excel should filled out the
"file name" field with a given name I will choose –excel uses book1 as
default and I do not wish this. Additionally the “save as†combo box should
be set to macro-enabled workbook.

How can I accomplish this?

Thanks

 

[JP]

Check out the Excel.Application.GetSaveAsFileName Method.

http://msdn.microsoft.com/en-us/library/aa195748(office.11).aspx

--JP