Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba Excel - Checking if changes were made
Hi friends, i hope somebody knows the right answer to this questions: 1.- Before closing the workbook, I need to know (programatically) if any changes were made to it, something like.. Sub BeforeClosing() If myWrkBk.ChangesWereMade = True then 'XXX End if End Sub 2.- My workbook (with the macro) is on the local server, and uses several other worbooks too. when I try to open one of those several workbooks it may be already open. Is there anyway i could know if that workbook is already running in some place in the server? Thanks in advance, Aldo. -- ajliaks ------------------------------------------------------------------------ ajliaks's Profile: http://www.excelforum.com/member.php...fo&userid=8196 View this thread: http://www.excelforum.com/showthread...hreadid=390474 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba Excel - Checking if changes were made
#1. You can check to see if excel thinks the workbook is "dirty" (needs
saving). if mywkrbk.saved = true then 'no outstanding changes else 'something could have changed since the last save end if #2. Take a look at this kb article: http://support.microsoft.com?kbid=138621 If you don't need to make changes and save that other workbook, maybe you could just open it readonly. ajliaks wrote: Hi friends, i hope somebody knows the right answer to this questions: 1.- Before closing the workbook, I need to know (programatically) if any changes were made to it, something like.. Sub BeforeClosing() If myWrkBk.ChangesWereMade = True then 'XXX End if End Sub 2.- My workbook (with the macro) is on the local server, and uses several other worbooks too. when I try to open one of those several workbooks it may be already open. Is there anyway i could know if that workbook is already running in some place in the server? Thanks in advance, Aldo. -- ajliaks ------------------------------------------------------------------------ ajliaks's Profile: http://www.excelforum.com/member.php...fo&userid=8196 View this thread: http://www.excelforum.com/showthread...hreadid=390474 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel ask to save when no changes were made? | Excel Discussion (Misc queries) | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
why does excel ask to save changes when none have been made? | Excel Discussion (Misc queries) | |||
I am using Excel and have made an error. | Charts and Charting in Excel | |||
Excel Saving and No changes made!! | Excel Programming |