it seemed like it should be asy.
here is what i did:

CrntCompfile = ActiveWorkbook.FullName
Workbooks("CrntCompFile").Activate

With or without the quotations, I get a "...subscript out of range..."
message.

I do not want to use a 'WindowNext.Activate' because the user may have other
stuff open.

Thansk for any suggestions

--
Message posted via http://www.officekb.com

Hi Almagg,

Try removing the quotes from the variable CrntCompFile.


However, why would you seek to activate the active
workbook?


---
Regards,
Norman



"Almagg via OfficeKB.com" <u33343@uwe wrote in message
news:70cd34632d4c6@uwe...
it seemed like it should be asy.
here is what i did:

CrntCompfile = ActiveWorkbook.FullName
Workbooks("CrntCompFile").Activate

With or without the quotations, I get a "...subscript out of range..."
message.

I do not want to use a 'WindowNext.Activate' because the user may have
other
stuff open.

Thansk for any suggestions

--
Message posted via http://www.officekb.com

Hi Almagg,

I intended to add that you should replace the Workbook's
FullName property with its Name property:



---
Regards,
Norman

norman

that did it. i thought i had done both, but apparently not.

well the user may have excel files open and my code goes thru three workbooks.

so i did not want to keep track using 'WindowNext.Activate'.

better i just refer to them by name.

thanks

al

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1