tfield98
asked on
Call Excel function from Delphi?
I'm successfully using OLE Automation to call Excel.
However, I haven't been able to figure the syntax (if there is any) for calling a VBA function and getting the result.
fxlApp.Run( ''Workbook.xls'!Macro'); Ā of course will run macro.
Is there similar syntax to call a user-written VBA string function, that could be assigned to a Delphi string.
Tom
However, I haven't been able to figure the syntax (if there is any) for calling a VBA function and getting the result.
fxlApp.Run( ''Workbook.xls'!Macro'); Ā of course will run macro.
Is there similar syntax to call a user-written VBA string function, that could be assigned to a Delphi string.
Tom
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER