application.run doesn't work

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

[Dave Peterson]

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

[grantj]

Application.Run "'Compass Form7.xls'!OpenFormSevenFile"

[Dave Peterson]

Is this a sign that it worked or failed?

grantj wrote:
>
> Application.Run "'Compass Form7.xls'!OpenFormSevenFile"
>
> --
> 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