| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save As
Ive reviewed the site for File Save as questions. They all seem to revolve
around the approach that requires the line: Application.DisplayAlerts = False. However, In a Macro I want to save the file, but I would like the Save As dialog box in excel to open up so the user can put the file in any directory they want it in. How would you do this? I'm sure it is esay but I can't figure it out! By the way, the Application.DisplayAlerts = True doesnt work! Any help would be appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prompt user to save file as {desired_name} and save it to a variab | Excel Programming | |||
| Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
| Excel marcos firing on file save as but not file save | Excel Programming | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
| Save As - Multiple Sheets fails to save as text file | Excel Programming | |||
Threaded Mode
