Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does a macro access its OWN workbook?
How does a macro access its OWN workbook (the workbook where the macro is defined), even when this is not the active workbook
I want to create a read-only 'reference' workbook that contains a collection of macros and a couple of worksheets with reference data. The various reference worksheets will have fixed names, but I want to avoid using a fixed name for the reference workbook My users will select some cells in a work-in-progress workbook and then invoke one of the macros (they will have the reference workbook open at the same time). The macros will need to access the currently selected cells as well as the reference data. Any help appreciate Maria |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does a macro access its OWN workbook?
you need to use the Thisworkbook to refer to the workbook where the macro is
located. and Activeworkbook where the macro is working on. Cesar "Maria" wrote in message ... How does a macro access its OWN workbook (the workbook where the macro is defined), even when this is not the active workbook? I want to create a read-only 'reference' workbook that contains a collection of macros and a couple of worksheets with reference data. The various reference worksheets will have fixed names, but I want to avoid using a fixed name for the reference workbook. My users will select some cells in a work-in-progress workbook and then invoke one of the macros (they will have the reference workbook open at the same time). The macros will need to access the currently selected cells as well as the reference data. Any help appreciated Maria |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does a macro access its OWN workbook?
Maria,
when accessing the book the code is in, use: ThisWorkbook.Sheets("index"). - and so on - Pete. -----Original Message----- How does a macro access its OWN workbook (the workbook where the macro is defined), even when this is not the active workbook? I want to create a read-only 'reference' workbook that contains a collection of macros and a couple of worksheets with reference data. The various reference worksheets will have fixed names, but I want to avoid using a fixed name for the reference workbook. My users will select some cells in a work-in-progress workbook and then invoke one of the macros (they will have the reference workbook open at the same time). The macros will need to access the currently selected cells as well as the reference data. Any help appreciated Maria . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does a macro access its OWN workbook?
Thanks Cesar and Pete - much appreciated
I do search google before posting questions, but it's not always easy when you don't yet know the exact word to search for... :o) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving macro from workbook to Personal Macro Workbook | Excel Discussion (Misc queries) | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Can't access to a Workbook | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |