The best way is to manipulate the excel object model. If you create and object with say
loExcel = CreateObject("excel.application")
then you can control almost anything that is available in Excel through VBA. If you are using VFP 7 with its excellent Intellisense, you could try this...
Hi,
You should upgrade to VFP7. With the introduction of IntelliSense, the whole object model of Excel is readily available and makes manipulation of your Excel file very easy indeed.
*************
loExcel=CREATEOBJECT('Excel.Application')
loExcel.visible=.t. && during development, if you wish...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.