Highlight cells in excel file via fox

[robsuttonjr]

I am creating an Excel file from the COPY command. I want to be able to change the layout of the excel file from Fox once file is created. Or can I highlight the cells and have the changes translate when exported to excel file. How does one manipulate excel files and modify programatically in Fox if possible? All of this needs to be done without user intervention.

 

[DEDMOD]

You'll probably have to use automation to control your table. Look for a help file beginning with 'VBAXL' and pull it up. Using automation requires some knowledge of Visual Basic. but there are lots of examples here and elsewhere if you need help.

And usually one or more people can help if you have specific questions to ask.

Dave Dardinger

 

[Kocherla]

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
loExcel.Workbooks.Add

and so on.....until
loExcel.quit
loExcel=""

Hope this helps
CK