Setting "save as" and "save"

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top