SaveAs Issue - different approach

[PLPE]

Hi,

This is the last part of my program & it's really bugging me.
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 AN
(*.XLS) NAME TO ANY LOCATION. [/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

 

[Bob Phillips]

Look up GetSaveAsFilename in the VBA help.