Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run "[TemplateName].[ModuleName].[MacroName]
Hello,
I am trying to call a sub in a module in an XLA from a regular excel document. I would like to pass along the Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Action to the xla So if my XLA is called Foo And the module is called bar How can I do this I have tried the following In the worksheet: Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Application.Run "foo.bar.Workbook_SheetBeforeDoubleClick", Sh, Target, Cancel End Sub which does not work also tried just Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Application.Run "Workbook_SheetBeforeDoubleClick", Sh, Target, Cancel End Sub In my XLA the sub in the module is: Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) <<my code End Sub however I never see the call coming into the XLA Any ideas? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run "[TemplateName].[ModuleName].[MacroName]
You just need the name of the workbook (with extension) and the macro:
Application.Run "Book1.xls!RunMe" -- Jim "greg" wrote in message ... | Hello, | I am trying to call a sub in a module in an XLA from a regular excel | document. | | I would like to pass along the | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | | Action to the xla | | So if my XLA is called Foo | And the module is called bar | How can I do this | I have tried the following | | In the worksheet: | | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | Application.Run "foo.bar.Workbook_SheetBeforeDoubleClick", Sh, Target, | Cancel | End Sub | | which does not work | | also tried just | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | Application.Run "Workbook_SheetBeforeDoubleClick", Sh, Target, Cancel | End Sub | | | | In my XLA the sub in the module is: | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | <<my code | End Sub | | | | however I never see the call coming into the XLA | | | Any ideas? | | thanks | | | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run "[TemplateName].[ModuleName].[MacroName]
So you mean
Application.Run "foo.xla.bar.Workbook_SheetBeforeDoubleClick", Sh, Target, "Jim Rech" wrote in message ... You just need the name of the workbook (with extension) and the macro: Application.Run "Book1.xls!RunMe" -- Jim "greg" wrote in message ... | Hello, | I am trying to call a sub in a module in an XLA from a regular excel | document. | | I would like to pass along the | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | | Action to the xla | | So if my XLA is called Foo | And the module is called bar | How can I do this | I have tried the following | | In the worksheet: | | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | Application.Run "foo.bar.Workbook_SheetBeforeDoubleClick", Sh, Target, | Cancel | End Sub | | which does not work | | also tried just | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | Application.Run "Workbook_SheetBeforeDoubleClick", Sh, Target, Cancel | End Sub | | | | In my XLA the sub in the module is: | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target | As Range, Cancel As Boolean) | <<my code | End Sub | | | | however I never see the call coming into the XLA | | | Any ideas? | | thanks | | | | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run "[TemplateName].[ModuleName].[MacroName]
This works for me:
Run "WorkbookWithExtension!ModuleName.SubName", Sh, Target, Cancel -- Jim "greg" wrote in message ... | So you mean | Application.Run "foo.xla.bar.Workbook_SheetBeforeDoubleClick", Sh, Target, | | | "Jim Rech" wrote in message | ... | You just need the name of the workbook (with extension) and the macro: | | Application.Run "Book1.xls!RunMe" | | -- | Jim | "greg" wrote in message | ... | | Hello, | | I am trying to call a sub in a module in an XLA from a regular excel | | document. | | | | I would like to pass along the | | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal | Target | | As Range, Cancel As Boolean) | | | | Action to the xla | | | | So if my XLA is called Foo | | And the module is called bar | | How can I do this | | I have tried the following | | | | In the worksheet: | | | | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal | Target | | As Range, Cancel As Boolean) | | Application.Run "foo.bar.Workbook_SheetBeforeDoubleClick", Sh, | Target, | | Cancel | | End Sub | | | | which does not work | | | | also tried just | | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal | Target | | As Range, Cancel As Boolean) | | Application.Run "Workbook_SheetBeforeDoubleClick", Sh, Target, Cancel | | End Sub | | | | | | | | In my XLA the sub in the module is: | | Public Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal | Target | | As Range, Cancel As Boolean) | | <<my code | | End Sub | | | | | | | | however I never see the call coming into the XLA | | | | | | Any ideas? | | | | thanks | | | | | | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filename!macroname as variables | Excel Discussion (Misc queries) | |||
Filename leads MacroName | Excel Programming | |||
Application.Run (WorkBook.Name & "!MacroName") | Excel Programming | |||
"WinForm Application" to act as "RTD Server" using .Net | Excel Programming | |||
Application.Run("MacroName", Args) | Excel Programming |