using Application.Run
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 |
using Application.Run
The workbook has to be open.
WhytheQ wrote: 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 |
All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com