Define a Workbook/WorkSheet Name by a String Value

**bdb1974** · 10-19-2009, 05:59 PM

Hi all the following code will put the worksheet name "SomeName" into
A1 to A10 on Sheet2.

Please Login or Register  to view this content.

I want to do the reverse. I want to use a string to define a Workbook name to activate. The workbook to be activated will be a variant in such the name
will always be what the value of the string.

Here's my attempt in which I'm getting a mismatch error:

Please Login or Register  to view this content.

NE HLP is Greatly Appreciated.

BDB

**Richard Buttrey** · 10-19-2009, 06:35 PM

Hi.

You just need to assign the string variable and then use:

Please Login or Register  to view this content.

HTH

**bdb1974** · 10-20-2009, 12:11 PM

Ok, I've tried setting it up the way Richard said.
Tried running and got an object doesn't support this method error
Why am I getting this error?
Is something not setup right?

Please Login or Register  to view this content.

Ne help in fixing this is appreciated.

Thanks,

BDB

**bdb1974** · 10-20-2009, 12:24 PM

Ok, I've found the error of my ways.

I made a few changes along with placing the following

Please Login or Register  to view this content.

into my code exactly by the advised method.
....and Wallah! It works!!!

Please Login or Register  to view this content.

Thank YOU, Richard Buttrey! and to everyoone else who's helped me b4.

**shg** · 10-20-2009, 12:25 PM

Can you back up a step and explain what you're trying to do?

**Richard Buttrey** · 10-20-2009, 12:29 PM

Hi,

I'm not clear why you are using an IF statement before the workbooks open instruction. If the workbook is already open in memory you don't need to open it, just activate it, otherwise you need to open it with the instruction I mentioned.

It also appears from the above that the variable StFileName 1 has not yet been assigned.

Rgds