Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling procedure | Excel Programming | |||
Calling sub procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming |