Check out the Excel.Application.GetSaveAsFileName Method.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

--JP

On Oct 1, 1:27*pm, Jess wrote:
"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