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)



"JMac" wrote in message
...
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