I can't seem to get this to work:
Dim wb As Workbook
Set wb = Workbooks.Open("z:\journal entry.xlsm")
Application.Run wb.Name & "!CreateSubmittal"

The Sub CreateSubmittal is designated as "Public Sub CreateSubmittal()" or
not.
The Sub is in the THisWorkbook object or Module1. Neither works.

Ideas? Thanks!

Hi Mike, It's all in the Quote marks. Note the Apotrophe enclosed in double
quotes on both ends of the file name variable.

Application.Run "'" & wb.Name & "'" & "!CreateSubmittal"




"Mike H." <(E-Mail Removed)> wrote in message
news:4727B3E3-802E-47EF-A2C8-(E-Mail Removed)...
>I can't seem to get this to work:
> Dim wb As Workbook
> Set wb = Workbooks.Open("z:\journal entry.xlsm")
> Application.Run wb.Name & "!CreateSubmittal"
>
> The Sub CreateSubmittal is designated as "Public Sub CreateSubmittal()" or
> not.
> The Sub is in the THisWorkbook object or Module1. Neither works.
>
> Ideas? Thanks!