Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object vs. New File in beforeSave event
I have build an Add-in and capture the Beforesave Event of all Excel
workbooks my users work with. occasionally my users will open excel workbooks from a database were the files are actually embeded objects. I have to treat these files differently than the files my user manipulates on the Hard drive. Currently I differentiate them by getting the OpenPath property from the Workbook. If it is an Object OpenPath="" all other files have OpenPath = "<path of some sort" which I then use for further validation. This works great as long as the file I'm working with is not a new workbook that has never been saved, in that instance OpenPath="" which makes my code think it's opend from the database as an object while it is not. Anybody can think of an easy way in the beforesave event to differentiate the Object from a new workbook ? This is probably realy simple I can just not think of it right now. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforeSave Event Question | Excel Programming | |||
BeforeSave event | Excel Discussion (Misc queries) | |||
Make "BeforeSave" event supply a default path and file name? | Excel Programming | |||
BeforeSave event | Excel Programming | |||
BeforeSave workbook event | Excel Programming |