Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1534
  • Last Modified:

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
0
tfield98
Asked:
tfield98
1 Solution
 
MerijnBSr. Software EngineerCommented:
this page is somewhat old, but you might find something useful here: http://www.djpate.freeserve.co.uk/AutoExcl.htm
0
 
tfield98Author Commented:
Debra's page is always good. I'd forgotten about it. Thanks!!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now