Procedure calling syntax
Hello,
I have an add-in that creates a menu from which I call procedures stored in the same add-in using the syntax: .OnAction = ThisWorkbook.Name & "!procedurename". What would be the syntax if I where to call a procedure stored in another loaded add-in, let's say in module3? Thank you. Eric |
Procedure calling syntax
Call a procedure in that same addin that does an Application.Run into the
other addin procedure (check VBA help). -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Eric" wrote in message ... Hello, I have an add-in that creates a menu from which I call procedures stored in the same add-in using the syntax: .OnAction = ThisWorkbook.Name & "!procedurename". What would be the syntax if I where to call a procedure stored in another loaded add-in, let's say in module3? Thank you. Eric |
Procedure calling syntax
Hello
First, OnAction:="procédurename" is suffisant Second, You call another procédure in another Workbook, with two solution 1. Application.run "workbook!procédudurename" 2. Call [Projectname].[modulename].procédurename J a c q u e s "Eric" a écrit dans le message de ... Hello, I have an add-in that creates a menu from which I call procedures stored in the same add-in using the syntax: .OnAction = ThisWorkbook.Name & "!procedurename". What would be the syntax if I where to call a procedure stored in another loaded add-in, let's say in module3? Thank you. Eric |
Procedure calling syntax
Thank you Bob
"Bob Phillips" wrote in message ... Call a procedure in that same addin that does an Application.Run into the other addin procedure (check VBA help). -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Eric" wrote in message ... Hello, I have an add-in that creates a menu from which I call procedures stored in the same add-in using the syntax: .OnAction = ThisWorkbook.Name & "!procedurename". What would be the syntax if I where to call a procedure stored in another loaded add-in, let's say in module3? Thank you. Eric |
Procedure calling syntax
Merci Jacques pour les precisions...
"Jacques ALARDET" wrote in message ... Hello First, OnAction:="procédurename" is suffisant Second, You call another procédure in another Workbook, with two solution 1. Application.run "workbook!procédudurename" 2. Call [Projectname].[modulename].procédurename J a c q u e s "Eric" a écrit dans le message de ... Hello, I have an add-in that creates a menu from which I call procedures stored in the same add-in using the syntax: .OnAction = ThisWorkbook.Name & "!procedurename". What would be the syntax if I where to call a procedure stored in another loaded add-in, let's say in module3? Thank you. Eric |
All times are GMT +1. The time now is 09:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com