Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the right approach? | Excel Worksheet Functions | |||
How to approach this? | Excel Discussion (Misc queries) | |||
How do I approach this? | Excel Programming | |||
Need new approach on forms I set up | Excel Programming |