SaveAs Issue - different approach

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.
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
.
.
Code will switch between different workbooks, so I would like to be able to refer to filename which user has saved.

Any & all help appreciated,
Jerry