Hi to all.
I have a problem with a procedure that create a big Excel file, with several sheets and a lot of lines.
Everything works fine except that sometimes an employee while is waiting opens another Excel file.
At that time the window opens the file that is creating in memory. And if he closes che windows the
procedure stops with the usual ole error.
Is there a way to block Excel from executing if is already running in memory ?
Or to intercept the errors inside the program like in VBA with the "On Error" statement ?
Thanks a lot.
Massimo
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Disable Excel from running
Just an idea. Can't you just make the procedure initiate new instance of Excel everytime?
I mean instead of
Just use oExcel := CreateObject( "Excel.Application" ) everytime. That way what the opening and closing of excel by the employee shouldn't affect your program because he's running a different instance of excel.
I mean instead of
TRY
  oExcel := GetActiveObject( "Excel.Application" )
CATCH
  TRY
    oExcel := CreateObject( "Excel.Application" )
  END
ENDJust use oExcel := CreateObject( "Excel.Application" ) everytime. That way what the opening and closing of excel by the employee shouldn't affect your program because he's running a different instance of excel.
FWH 11.08/FWH 19.12
BCC5.82/BCC7.3
xHarbour/Harbour
BCC5.82/BCC7.3
xHarbour/Harbour
Hi.
This is a good idea. I must make some tests.
Thanks a lot.
Massimo