Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file, then call macro... won't work
The following code won't work right: Sub openthenrun() Workbooks.Ope Filename:="C:\Kieran\Posturedata1\posturetemplate. xls" Application.Run "PERSONAL.XLS!IMPORT" End Sub If I try to run this, it stops after opening the first file, and wil not continue on to run the "IMPORT" macro. I also tried placing the open filename line above into the code for th "IMPORT" macro, and the same thing happened. Any hints? Thanks... -Kiera -- Kieran102 ----------------------------------------------------------------------- Kieran1028's Profile: http://www.excelforum.com/member.php...fo&userid=1567 View this thread: http://www.excelforum.com/showthread.php?threadid=27709 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button fails to call macro when open an Excel via Intranet | Excel Discussion (Misc queries) | |||
Button fails to call macro when open an Excel file from web | Excel Programming | |||
How to call File Open / Save Window in a Macro | Excel Programming | |||
Open Another Workbook and Call Macro | Excel Programming | |||
Auto_Open vs Open and call macro --priority question | Excel Programming |