Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Open Excel as readonly
Message
De
01/02/2004 13:34:21
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00872785
Message ID:
00872786
Vues:
19
Hey Bob

Check the Windows task manager for occurances of Excel. At each VFP crash, there will be another instance of Excel. Close them all and when your program loads the spreadsheet again, everything will be fine.

>My first attempts at reading Excel from VFP. While I'm debugging, sometimes when the program crashes, it leaves the Excel worksheet in a readonly state. That's fine for the VFP program, since I'm only reading it. But it means I can't go to Excel and change my test data. Once its readonly, I have to reboot to clear the problem.
>
>It seems I should open the worksheet as ReadOnly but I don;t have info on how to do this.
>
>I have
>
>oExcel=CreateObject("Excel.Application")
>oWorkbook = oExcel.Workbooks.Open(thisform.xlsname)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform