November 1st, 2007, 12:28 PM
|
|
Registered User
|
|
Join Date: Nov 2007
Posts: 1
Time spent in forums: 16 m 28 sec
Reputation Power: 0
|
|
|
Need Help Debugging Script/Error in Script - Event BeforeClose() from Excel (ActiveX)
I have a script which opens Excel and loads a file.
This work fine.
Now I want to know when the User wants to close Excel.
Then I want to do some more scripting.
I tried to assign a (JS)function onBeforeClose(cancel) on myworkBook.BeforeClose.
But this doesn't work. Whats wrong in my code?
MyCode:
Code:
function OpenExcelDoc(file)
{
//Create ActiveXObject
...
excel.Visible = true;
myworkbook = excel.Workbooks.Open(file);
myworkbook .BeforeClose = function(){OnBeforeClose};
top.blur();
}
void OnBeforeClose(cancel)
{
alert('Attention: Close Document');
}
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
