General information
Category:
COM/DCOM and OLE Automation
>I can open my template file, save the workbook to a new file so that I can push the data into it.
>Pushing the data in is not the problem, Excel keeps locking up my system. I believe it is because I am not properly closing the template file after I save it and then opening the new file.
>Does this help?
Yup, more clear. :-)
First though is, can you do this action manually with Excel yourself (not using automation). Does it lock up?
If that works fine, turn on the debugger and step through the code to see what is going on. Also, while doing development, put
loExcel.Visible = .T. right after creating loExcel so that you can see what is going on.
Just a note here, looking Tamar's and Della's "Office Automation with VFP", then syntax for opening a template is
oBook = oExcel.Workbooks.Add("c:\test\template.xlt").
Previous
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