Thread: Saved seems not to work
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_46_] Leith Ross[_46_] is offline
external usenet poster
  
Posts: 1
Default Saved seems not to work

Hello Guido,

Before a workbook is saved the Workbook.Path = "" and Workbook.Saved =
False. Once you Save As, Excel sets the Workbook.Path. That's how Excel
knows the Workbook has been saved.

You can bring up the Save As dialog in your code at anytime regardless
of these 2 property settings.

DISPLAY SAVE AS DIALOG:
Application.Dialogs(xlDialogSaveAs).Show

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=380180

Reply With QuoteReply With Quote