using Application.Run

[WhytheQ]

if the xls file xxx is open and I try the following then Bob's your
Uncle the code runs fine:

Sub runMe()
Application.Run "xxx.xls!xxx"
End Sub

if the xls file is closed and I run the following:

Sub runMe()
Application.Run "'C:\Documents and Settings\xxx.xls!xxx"
End Sub

.....the target file xxx opens but it then errors out before running
the macro

Anbody know why this happens

Any help appreciated
JasonQ

 

[Dave Peterson]

The workbook has to be open.

if the xls file xxx is open and I try the following then Bob's your
Uncle the code runs fine:

Sub runMe()
Application.Run "xxx.xls!xxx"
End Sub

if the xls file is closed and I run the following:

Sub runMe()
Application.Run "'C:\Documents and Settings\xxx.xls!xxx"
End Sub

....the target file xxx opens but it then errors out before running
the macro

Anbody know why this happens

Any help appreciated
JasonQ