"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