Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Workbook Copying
Message
 
À
03/10/2001 16:11:21
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00563845
Message ID:
00563870
Vues:
16
>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
Fil
Voir

Click here to load this message in the networking platform