Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Workbook Copying
Message
 
 
To
03/10/2001 16:11:21
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00563845
Message ID:
00563870
Views:
15
>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
Map
View

Click here to load this message in the networking platform