How does a macro access its OWN workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
How does a macro access its OWN workbook (the workbook where the macro is
Click to expand...
defined), even when this is not the active workbook?
I want to create a read-only 'reference' workbook that contains a
Click to expand...
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
Click to expand...
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.
 
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
Click to expand...
where the macro is defined), even when this is not the
active workbook?
I want to create a read-only 'reference' workbook that
Click to expand...
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
Click to expand...
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.
 
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)
 
Back
Top