Information générale
Catégorie:
COM/DCOM et OLE Automation
>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)
The third parameter to the Open method determines whether it's read-only or not. Do be aware, though, that Office's interpretation of read-only isn't exactly what you might think. It prevents you from saving it back to the original file, but doesn't prevent changes or a SaveAs.
Tamar
Précédent
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