Solved

Call Excel function from Delphi?

Posted on 2007-11-20
2
1,497 Views
Last Modified: 2012-06-27
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
Comment
Question by:tfield98
2 Comments
 
LVL 19

Accepted Solution

by:
MerijnB earned 400 total points
ID: 20326225
this page is somewhat old, but you might find something useful here: http://www.djpate.freeserve.co.uk/AutoExcl.htm
0
 

Author Closing Comment

by:tfield98
ID: 31410207
Debra's page is always good. I'd forgotten about it. Thanks!!
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question