using Application.Run

  • Thread starter Thread starter WhytheQ
  • Start date Start date
W

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
 
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
Click to expand...
 
Back
Top