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 - 15 Apr 2008 22:20 GMT
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:
[quoted text clipped - 16 lines]
> Any help appreciated
> JasonQ

Signature
Dave Peterson