Maybe...

Application.Run "'compass form7.xls'!OpenFormSevenFile"

(note the additional apostrophes.)


grantj wrote:

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

--

Dave Peterson