Link to home
Start Free TrialLog in
Avatar of tfield98
tfield98Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of MerijnB
MerijnB
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tfield98

ASKER

Debra's page is always good. I'd forgotten about it. Thanks!!