Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What code would be running while the dialog is visible. The beforesave
event has ended before the dialog is displayed. Use the Application.GetSaveAsFilename dialog to return that information to you and then you can determine whether to save the file or not. -- Regards, Tom Ogilvy "blc" wrote in message ... Hello all, Anyone have any idea how I can get a reference to the "Save As" dialog box that is instantiated when a user clicks the "Save As" button on the Excel MAIN toolbar??? I would like to be able to determine what the new filepath and filename will be in the Workbook_BeforeSave event before the Save occurs... Thank you very much, blc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Save In" dialog (dialogue) issue | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
"Save As WebPage" dialog box missing | Excel Discussion (Misc queries) | |||
How do you turn off "Save a copy/Overwrite changes" dialog box | Excel Discussion (Misc queries) | |||
Getting "Save as PDF File" Dialog at end of printing to PDF using PDFwriter | Excel Programming |