Posted to microsoft.public.excel.programming

Almagg via OfficeKB.com Almagg via OfficeKB.com is offline

external usenet poster

Posts: 9

activating a workbook

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Activating Workbook	Chip Pearson	Excel Programming	3	December 30th 06 01:53 AM
Activating Workbook	Rod Gill	Excel Programming	1	December 29th 06 10:09 PM
Activating a workbook	Boldie	Excel Programming	5	July 19th 06 03:15 AM
activating a workbook	VB Script for Excel	Excel Programming	12	March 22nd 06 07:55 AM
Activating a workbook help	bmwmcrider	Excel Programming	1	October 21st 03 01:48 PM

All times are GMT +1. The time now is 04:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us