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