This works for me:
Run "WorkbookWithExtension!ModuleName.SubName", Sh, Target, Cancel
--
Jim
"greg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| So you mean
| Application.Run "foo.xla.bar.Workbook_SheetBeforeDoubleClick", Sh, Target,
|
|
| "Jim Rech" <(E-Mail Removed)> wrote in message
| news:%(E-Mail Removed)...
| > You just need the name of the workbook (with extension) and the macro:
| >
| > Application.Run "Book1.xls!RunMe"
| >
| > --
| > Jim
| > "greg" <(E-Mail Removed)> wrote in message
| > news:(E-Mail Removed)...
| > | 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
| > |
| > |
| > |
| > |
| >
| >
|
|
|
Similar Threads
