I have a macro that opens another Excel spreadsheet (Workbooks.Open
Filename:="F:\Compass\Compass Form7.xls", UpdateLinks:=3), then runs
another macro (Application.Run OpenFormSevenFile). The macro, however,
does not run. I have also tried the following without successs:
Application.Run ("Compass Form7.xls!OpenFormSevenFile")
Call OpenFormSevenFile
OpenFormSevenFile
Any suggestions?
--
grantj
------------------------------------------------------------------------
grantj's Profile:
http://www.excelforum.com/member.php...o&userid=35021
View this thread:
http://www.excelforum.com/showthread...hreadid=547573