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

Similar Threads

Adding code right after the "Save As" dialog box 2
Save it giving as a name the content of a cell 3
Need help to increment default WorkBook name in code 7
Prevent saving and allow only through Macro 2
file locks when saving shared workbooks 2
Deleting all code in new file only (creating using save as) 15
Create form and Data separately 4
FP closes unexpectedly when using "save as" 3

Top