SaveAs Issue - different approach
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] [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 |
SaveAs Issue - different approach
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 |
All times are GMT +1. The time now is 02:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com