Look at GetSaveAsFilename in VBA help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sally" wrote in message
...
Hi,
Please can someone tell me the VBA code to prompt a user to 'save as' a
file
in excel. the folders will have to be specified...
--
Thanks
Sally