Look up GetSaveAsFilename in the VBA help.

--
HTH

Bob Phillips

"PLPE" wrote in message
...

Hi,

This is the last part of my program & it's really bugging me. I
searched for SaveAs here but couldn't find any similar problem.

I WANT A MACRO WHICH WILL ALLOW THE USER TO SAVE THE FILE BY ANY
(*.XLS) NAME TO ANY LOCATION. [/b]
[b]HOW CAN THIS BE DONE?


What I foresee will happen upon execution is;
1. user will click but to execute program
2. SaveAs dialog box appears
3. user saves file as XYZ.xls