>>Hi there,
>>
>>I need to have access to full range of commands to manipulate excel sheets which I exported from VFP.
>>oExcel = CREATEOBJECT("Excel.Application")
>>
>>Is there any available reference to find properties and methods to work with oExcel object to take maximum advantage of automation process?
>>
>>Thanks
>
>Three references:
>
Saving a macro in Excel, you can usually get at least a preliminary version of the code, which then requires some adaptations for VFP.
>I wrote an introductory article on Excel Automation, Universal Thread Magazine, September 2002.
>There is a book available on Office Automation from Visual FoxPro. I don't remember the title; one of the two authors is Tamar Granor.
It's a book by Della Martin and Tamar Granor.
See also Re: Visual Basic for Applications question Thread #1214823 Message #1216104
If it's not broken, fix it until it is.
My Blog