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)
 
Back
Top