LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 367
Default Switch Between Workbooks

I need to toggle between two different open workbooks (these two would be the
only open visible workbooks at the time). The problem is that I don't always
know what the name of the workbooks will be. Could someone please help with
some code that would take the current active workbook, designate that
workbook as WB1, and then designate the other open workbook as WB2. In the
end, I want to be able to switch back and forth through the two as follows:

WB1.Activate
WB2.Activate

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Code to switch between workbooks [email protected] Excel Programming 3 October 11th 06 01:32 AM
Using alt-tab to switch between Excel workbooks under the same session Kjetil Excel Discussion (Misc queries) 0 June 22nd 06 03:39 PM
How to switch between different workbooks? Ivan Excel Programming 2 December 28th 05 06:30 AM
Switch Workbooks Ronbo Excel Programming 1 February 29th 04 06:58 PM
Switch between workbooks Newbie Excel Programming 1 January 7th 04 09:34 PM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"