Save as with suggested filename

W

WOMBAT

I want to save an Excel workbook using a name calculated
by VBA, but I want to give the user the opportunity to
alter the name. I thought I could do this by using a
xlDialogSaveAs, but then how do I cause VBA to write the
suggested name into the Filename box so that the user can
check & change it if necessary it before hiiting SAVE?
 

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