keepingbusy
Programmer
Hi
How do I stop the created excel file from opening:
Code:
USE MYFILE
STORE "completed" TO mfile
EXPORT TO &mfile TYPE XLS
STORE SYS(5)+SYS(2003)+"\"+TRIM(mfile)+".xls" TO mfileopen
oXL = CREATEOBJECT("Excel.Application")
oWorkbook = oXL.Workbooks.Open(mFileOpen)
oRange = oWorkbook.Sheets[1].Rows[1]
oRange.Delete()
oXL.Visible = .T.
I've also tried to remove oWorkbook = oXL.Workbooks.Open(mFileOpen) but then I get file not found.
I just want the file to be created in the background and I'll show a =messagebox when completed.
VFP9
Many thanks
Lee