>>>>I've got a comma separated values file (csv) that opens in a webBrowser control hosted in a VFP9 form. It appears rendered as a spreadsheet (Excel) and is editable.
>>>>
>>>>How can I prevent the contents from being changed?
>>>>
>>>>I've tried to set the file as readonly, but, it does not help; the user can still edit the content.
>>>>
>>>>TIA
>>>>Mike
>>>
>>>
#define xlNoSelection -4142
>>>
>>>oXLS = myWBControl.Object.Document
>>>oExcel = oXLS.Application
>>>oExcel.CommandBars("Standard").visible = .F.
>>>oExcel.CommandBars("Formatting").visible = .F.
>>>oExcel.ActiveWorkbook.ActiveSheet.EnableSelection = xlNoSelection
>>>oExcel.ActiveWorkbook.ActiveSheet.Protect(,,.T.,,.T.)
Cetin
>>
>>Hi Cetin,
>>
>>Thanks for the reply.
>>
>>After I've called the browser's navigate2("file://somepath/some_csv_file.csv") method I've added your code suggestion by modifying "myWBControl" to my object name, When I run the code I receive a Program Error - "OLE error code 0x80020006: Unknown name." when the line containing oXLS.Application tires to execute. From the VFP debugger, I can see that the object oXLS does not have this method. Did I not do this correctly?
>>
>>Mike
>
>If it doesn't then it is not opening with excel really. You may instead navigate to an xls file (an empty dummy one maybe) and then open the csv as a workbook.
>
>PS: Why don't you get that csv into a cursor and browse that one in a grid instead of a web browser control.
>Cetin
I'll give the "dummy file" a try.
I'm trying to add the ability to view "almost any type of document (within reason)" without having to shell execute and startup another application to do so. Do you know of another approach? Thus far, CHM files are the only ones the can't open directly in the browser.
Mike