Macro to close workbook with prompt

  • Thread starter Thread starter JMac
  • Start date Start date
J

JMac

I would like to run a macro that will save the workbook in a
particular directory, but it will prompt the user for the file name.
Is this possible?

TIA,

Josh
 
Look at GetSaveAsFilename in VBA help. This will return the user selected
name, you will still need to save it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You must log in or register to reply here.

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

Close all without saving and exit without prompts 8
Need help on VBA excel macro and API to close an external application 0
macro to call other macros 1
Macro to update active workbook in one folder 8
Save all sheets in a new workbook 7
Open Dialog Box 1
Prompt User to Select Macro to Run? 1
Getting rid of Macro and Update Prompt 1

Back
Top