Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SaveAs | Excel Discussion (Misc queries) | |||
SaveAs - VBA | Excel Discussion (Misc queries) | |||
SaveAs - VBA | Excel Discussion (Misc queries) | |||
VBA SaveAs Value | Excel Discussion (Misc queries) | |||
SaveAs needed if new | Excel Programming |