| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-word WB name
Excel XP & Win XP
I have 2 workbooks open, AAA.xls & BBB.xls. I want to run macro TestBBB, located in BBB.xls, from within AAA.xls. The code (in AAA.xls): Application.Run ("BBB.xls!TestBBB") works fine (thanks to Mark Dullingham). Now change the scenario: Change the name of the BBB.xls WB to "BB B.xls" (insert a space in the name) The code (in AAA.xls): Application.Run ("BB B.xls!TestBBB") produces an error "Macro 'BB B.xls!TestBBB' cannot be found." My question: What is the proper syntax for the Application.Run statement when the target workbook has a multi-word name? Thanks for your time. Otto |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi-word WB name
Application.Run ("'BB B.xls'!TestBBB")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Otto Moehrbach" wrote in message ... Excel XP & Win XP I have 2 workbooks open, AAA.xls & BBB.xls. I want to run macro TestBBB, located in BBB.xls, from within AAA.xls. The code (in AAA.xls): Application.Run ("BBB.xls!TestBBB") works fine (thanks to Mark Dullingham). Now change the scenario: Change the name of the BBB.xls WB to "BB B.xls" (insert a space in the name) The code (in AAA.xls): Application.Run ("BB B.xls!TestBBB") produces an error "Macro 'BB B.xls!TestBBB' cannot be found." My question: What is the proper syntax for the Application.Run statement when the target workbook has a multi-word name? Thanks for your time. Otto |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi-word WB name
You need single quotes around the filename.
ie Application.Run ("'BB B.xls'!TestBBB") "Otto Moehrbach" wrote: Excel XP & Win XP I have 2 workbooks open, AAA.xls & BBB.xls. I want to run macro TestBBB, located in BBB.xls, from within AAA.xls. The code (in AAA.xls): Application.Run ("BBB.xls!TestBBB") works fine (thanks to Mark Dullingham). Now change the scenario: Change the name of the BBB.xls WB to "BB B.xls" (insert a space in the name) The code (in AAA.xls): Application.Run ("BB B.xls!TestBBB") produces an error "Macro 'BB B.xls!TestBBB' cannot be found." My question: What is the proper syntax for the Application.Run statement when the target workbook has a multi-word name? Thanks for your time. Otto |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi-word WB name
Hi, Otto,
Enclose the workbook name in single quotes. Application.Run("'BB B.xls'!TestBBB") -- Hope that helps. Vergel Adriano "Otto Moehrbach" wrote: Excel XP & Win XP I have 2 workbooks open, AAA.xls & BBB.xls. I want to run macro TestBBB, located in BBB.xls, from within AAA.xls. The code (in AAA.xls): Application.Run ("BBB.xls!TestBBB") works fine (thanks to Mark Dullingham). Now change the scenario: Change the name of the BBB.xls WB to "BB B.xls" (insert a space in the name) The code (in AAA.xls): Application.Run ("BB B.xls!TestBBB") produces an error "Macro 'BB B.xls!TestBBB' cannot be found." My question: What is the proper syntax for the Application.Run statement when the target workbook has a multi-word name? Thanks for your time. Otto |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi-word WB name
How about:
Application.Run "'BB B.xls'!TestBBB" (not ()'s required) I like: dim BBBWkbk as workbook set BBBwkbk = workbooks("bb b.xls") 'or whatever Application.Run "'" & BBBwkbk.name & "'!TestBBB" By using a variable, I only have one location to change if/when that workbook needs to change. Otto Moehrbach wrote: Excel XP & Win XP I have 2 workbooks open, AAA.xls & BBB.xls. I want to run macro TestBBB, located in BBB.xls, from within AAA.xls. The code (in AAA.xls): Application.Run ("BBB.xls!TestBBB") works fine (thanks to Mark Dullingham). Now change the scenario: Change the name of the BBB.xls WB to "BB B.xls" (insert a space in the name) The code (in AAA.xls): Application.Run ("BB B.xls!TestBBB") produces an error "Macro 'BB B.xls!TestBBB' cannot be found." My question: What is the proper syntax for the Application.Run statement when the target workbook has a multi-word name? Thanks for your time. Otto -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi-word WB name
To All
That worked great. Thanks for your time. Otto "Otto Moehrbach" wrote in message ... Excel XP & Win XP I have 2 workbooks open, AAA.xls & BBB.xls. I want to run macro TestBBB, located in BBB.xls, from within AAA.xls. The code (in AAA.xls): Application.Run ("BBB.xls!TestBBB") works fine (thanks to Mark Dullingham). Now change the scenario: Change the name of the BBB.xls WB to "BB B.xls" (insert a space in the name) The code (in AAA.xls): Application.Run ("BB B.xls!TestBBB") produces an error "Macro 'BB B.xls!TestBBB' cannot be found." My question: What is the proper syntax for the Application.Run statement when the target workbook has a multi-word name? Thanks for your time. Otto |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
| Converting a Word doc to a multi-column Excel spreadsheet | Excel Worksheet Functions | |||
| Merge Excel multi columns into Word | Excel Worksheet Functions | |||
| embed multi-page Word document | Excel Discussion (Misc queries) | |||
| Multi-Page Word Doc Linked to Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
