General information
Category:
Reports & Report designer
Title:
Reporting using Excel, Excel remains open
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only