Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |