Hi!

I do not know really the answer because I never worked this way. I just know about this approach because it was used by one of russian VFP developers.

Just a suggestion: I suspect that WEB Browser Control does not save changes amde to Excel document into the file. That might be a reson why after editing the document WEB Browser Control does not want to navigate to another file. Try to save the file before navigating to another file. Unfortunately, I'm not sure how to do this programmatically (manually just press Ctrl+S keys when Excel sheet is focused). Maybe, through document object or something like that you can get an access to the OLE Automation objects model for Excel document and use its methods to save the file.

>I have the WEB Browser control working pretty well, but I'm having a problem I can't figure out.
>
>The form has a grid with a list of xls files and a web browser control. The AfterRowColChange event calls a custom method that does the following:
>
>

>WITH thisform
>   lcFile = ALLTRIM(xlsdisplay.chartname)
>   IF .curxls # lcFile
>      .curxls = lcFile
>      .pgfMain.pgEarnView._webbrowser1.navigate(lcFile)
>   ENDIF
>ENDWITH
>

>
>This works fine, but if I make a change to the spreadsheet in the webcontrol, then click on the grid, I usually get the following error: "The action cannot be completed because the other program is busy. Click the appropriate button on the task bar to activate the busy program and correct the problem."
>
>Do you know if I'm using this control in a bogus way, or if there's something else going on here?
>
>Thanks again!
>
>Rob
>
>>Hi!
>>
>>No.
>>You can, however, display Excel file separately in WEB Browser control, so user will have some simple editing, as well as it will be embedded on the VFP form. This approach also solves a problem with "Jumping" and resizing of the native VFP OLE control that displays MS Office documents like Excel sheet when editin it.
>>
>>>Hi,
>>>
>>>Is there anyway to have a LINKed general field appear embedded in an oleboundcontrol rather than opening an instance of excel.
>>>
>>>When I APPEND GENERAL with out LINK, the spreadsheet appears embedded the control.
>>>
>>>When I APPEND GENERAL LINK, regardless of what param I send to DOVERB, the spreadsheet opens in excel instead of being embedded in my oleboundcontrol.
>>>
>>>TIA!
>>>
>>>Rob