General information
Category:
Coding, syntax & commands
>>>Look at the help in VFP about CREATEOBJECT(). It actually shows you how to
>>>create an instance of excel. Once you have the object reference to excel,
>>>you can do anything you want with it.
>>
>>One thing I couldn't find: how do I run an excel macro? Can't figure out
>>the hierarchy, syntax or whatever is necessary.
>>(VFP 5.0 and Office 97)
>
>You could record the macro and edit/copy the code into your VFP application and do all the commands through OLE.
>
>
>Wayne
To complement and support your point, Wayne, i found that, as long as your Excel Activity is not too VBA-intensive, keeping the control of EXCEL from VFP is a very good solution (that is what i do).
Contrary to Word 97 where controlling from VFP is buggy and limited, you have much stronger programmatic control from VFP where from you can easily tailor your EXCEL VBA code and master Excel objects (including collections with FOR EACH coding structure).
But your VFP code is too intensive like in :
PUBLIC oExcel
oExcel = GETOBJECT("XLS")
oExcel.Application.Visible = .T.
oExcel.Windows(1).Visible = .T.
iLine = 1
SCAN ALL
FOR icolumn=1 TO FCOUNT()
oExcel.Sheets(1).cells(iLine,iColumn).Value = EVALUATE(FIELD(iColumn))
ENDFOR
iLine = iLine + 1
ENDSCAN
RETURN
This become awfully time-consuming. Triggering EXCEL VBA code might solve the speed issue when this is required. I have not tested it.
Regards to all
But I have not tested the code to run a macro from VFP. Which i suppose would bring you additional power.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only