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