>Hi
>
>I want to automate a spreadsheet hosted on a OLE ActiveX control on form.
>
>1) Intellisense does seem to be working for the control? (would be really useful :)
>
>2) How do I reference my spreadsheet in my control
>
>I know I can automate an excel spreadsheet from VFP, but the customer want the spread sheet to appear on a VFP form from within an existing application I wrote in VFP
>
>My "proof of concept" code currently looks like this:-
>
>
>
>Any help extremely appreciated
>
>Kind regards
>
>Rob

FWIW do not directly provide an Excel sheet on a form. Instead (and only if you have to do it) use a web browser (shell.explorer) control on form and navigate to an xlsx file.

PS: I posted sample codes years ago, but now unfortunately I can't even search my own messages. You or someone else might get to one of those messages.