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)