Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reporting using Excel, Excel remains open
Message
From
13/03/2003 14:07:00
Dave Crowley
Alliance Marketing Services
Jamison, Pennsylvania, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Reporting using Excel, Excel remains open
Miscellaneous
Thread ID:
00765514
Message ID:
00765514
Views:
82
I am hoping someone can help me.

Using a FoxPro program to output data into an Excel sheet. The program runs
fine, but leaves an invisible excel open. The only way to determine whether
or not an excel is open is to look in the task manager (Alt + Ctrl + Del).
The computer completely locks up until the invisible excel in the task
manager has been cancelled.

Commands used are

oleexcel = CREATEOBJECT("Excel.application")
oleexcel.APPLICATION.workbooks.OPEN(&rpt_name)
oleexcel.APPLICATION.worksheets("Sheet1").ACTIVATE

oleexcel.activeworkbook.SAVE
oleexcel.APPLICATION.workbooks(1).saved = .T.
oleexcel.APPLICATION.workbooks(1).CLOSE
Next
Reply
Map
View

Click here to load this message in the networking platform