View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Question "Save As" dialog box... (-:

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