| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Linear Mode
