ExcelBanter - application.run doesn't work

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - application.run doesn't work (https://www.excelbanter.com/excel-discussion-misc-queries/91712-application-run-doesnt-work.html)

grantj

application.run doesn't work

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

application.run doesn't work

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 doesn't work

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

application.run doesn't work

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

All times are GMT +1. The time now is 02:54 PM.