Greetings,

I open one workbook which opens another workbook using the workbook
open event of the first workbook. The first workbook is the active
workbook. The first workbook's name is not always the same but it's
code is.

Is there a way that the name of the first workbook or a variable with
that name assigned to it, be used in the second workbook's code?

I tried ThisWorkbook but could not get it to work.

Any help would be greatly appreciated.

-Minitman

Hi!

"ThisWorkbook" property refers to the workbook who contains the code.

Use the "ActiveWorkbook" property.

John


Ο χÏ�ήστης "Minitman" Î*γγÏ�αψε:

Greetings,

I open one workbook which opens another workbook using the workbook
open event of the first workbook. The first workbook is the active
workbook. The first workbook's name is not always the same but it's
code is.

Is there a way that the name of the first workbook or a variable with
that name assigned to it, be used in the second workbook's code?

I tried ThisWorkbook but could not get it to work.

Any help would be greatly appreciated.

-Minitman

Hi J_J, I am not so sure the OP can use ActiveWorkbook to refer back to the
opening workbook. If the code is running in wb 2 then wb 2 is the active
workbook.
A crude but effective way is to store the wb 1 name in a cell of a specific
sheet and then call that cell from wb 2 macro.

"John_John" wrote:

Hi!

"ThisWorkbook" property refers to the workbook who contains the code.

Use the "ActiveWorkbook" property.

John


Ο χÏ�ήστης "Minitman" Î*γγÏ�αψε:

Greetings,

I open one workbook which opens another workbook using the workbook
open event of the first workbook. The first workbook is the active
workbook. The first workbook's name is not always the same but it's
code is.

Is there a way that the name of the first workbook or a variable with
that name assigned to it, be used in the second workbook's code?

I tried ThisWorkbook but could not get it to work.

Any help would be greatly appreciated.

-Minitman

Hey John,

Thanks for the reply.

Good call. That seems to do the job if I make the first workbook
active before I start the code

Thanks.

-Minitman
(My company is called Minit Maids of Austin which makes me the
Minitman) :^


On Wed, 10 Sep 2008 16:43:01 -0700, John_John
wrote:

Hi!

"ThisWorkbook" property refers to the workbook who contains the code.

Use the "ActiveWorkbook" property.

John


? ??????? "Minitman" ???????:

Greetings,

I open one workbook which opens another workbook using the workbook
open event of the first workbook. The first workbook is the active
workbook. The first workbook's name is not always the same but it's
code is.

Is there a way that the name of the first workbook or a variable with
that name assigned to it, be used in the second workbook's code?

I tried ThisWorkbook but could not get it to work.

Any help would be greatly appreciated.

-Minitman

Check out Chip Pearson's site for more info on variables between workbooks.

http://www.cpearson.com/excel/TrulyGlobalVariables.htm

"Minitman" wrote:

Greetings,

I open one workbook which opens another workbook using the workbook
open event of the first workbook. The first workbook is the active
workbook. The first workbook's name is not always the same but it's
code is.

Is there a way that the name of the first workbook or a variable with
that name assigned to it, be used in the second workbook's code?

I tried ThisWorkbook but could not get it to work.

Any help would be greatly appreciated.

-Minitman