application.run doesn't work

G

grantj

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?
 
D

Dave Peterson

Maybe...

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

(note the additional apostrophes.)
 
Top