SaveAs needed if new
 

Maybe you can use this

If Len(ThisWorkbook.Path) = 0 then
Or use ActiveWorkbook.Path

If the file is not saved the len = 0

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Wes Jester" wrote in message ...
Is there a method to invoke something similar to the "standard" save.
My users can open an exisitng spreadsheet or a new S/S using a template.
As part of the app, I need to determine if the sheet they are working on
has already been saved. If so, I can simply issue a object.Save.

Otherwise, I would like the app to mimic the Save action that happens
when you save a workbook the first time.

Essentially, I want to do exactly what EXCEL does when one tries to do a
Save the first time. I just don't know how to do it in code.

Any help is appreciated.


Wes

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!