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
| |
| |
| |
| |
|
|
|
|
|