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