ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calling VBA add-in functions/subs from another Excel file. (https://www.excelbanter.com/excel-programming/310208-calling-vba-add-functions-subs-another-excel-file.html)

Bret Holle

Calling VBA add-in functions/subs from another Excel file.
 
Is it possible to put VBA code into a workbook that will call either a Sub
or Function that is sitting inside an installed add-in?

Thanks,
Bret



Robin Hammond[_2_]

Calling VBA add-in functions/subs from another Excel file.
 
Bret,

This is a function call example
ReturnValue = Application.Run("EFALoader.xla!Authenticate")

Robin Hammond
www.enhanceddatasystems.com

"Bret Holle" wrote in message
...
Is it possible to put VBA code into a workbook that will call either a Sub
or Function that is sitting inside an installed add-in?

Thanks,
Bret






All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com