Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Execute a Macro from one excel Application to another Application | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |