VBAXL9.CHM looks like it will work for me.
But I'm having a hard time just getting it started. As a test I tried the following:
oExcel = createobject("Excel.application")
oExcel.workbooks.open('C:\TEST\STOCK UPDATE.xls')
But I get nothing...Any ideas?
Many Thanks!
>Get the VBAXL8.HLP or VBAXL9.CHM from your Office97 or 2000 CD. Office2000 has far better help but the 97 version will do well.
>
>>Does anyone know any good resources on Excel Automation? Just simple stuff like opening, modifing, and closing spreadsheets.
>>
>>In the VFP solutions I found some good examples that created some spreadsheets, but I need a bit more documentation.
>>
>>Thanks in advance!!!