Information générale
Catégorie:
COM/DCOM et 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").
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement