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: 6
Default Window Selection based on name pattern

Hi Group,
I was wondering if there is a way in VBA to make that excel
spreadsheet as active window which has name ending with a fixed
string? For example: if a lot of excel spreadsheets are open at the
same time, all in the same session of course, my code should identify
the spreadsheet whose name is ending with something like
xxxxx_practice.xls and make it as active window.

Many thanks!

Best Regards,
Abhijat
 
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
attempting to format a color pattern in tab 3, based tab 2 and tab mturboman Excel Discussion (Misc queries) 5 February 24th 10 09:10 AM
How do I Propogate Cell Selection Pattern? archsmooth Excel Worksheet Functions 0 January 9th 08 08:31 PM
Selection Window Mike Excel Discussion (Misc queries) 0 November 14th 07 05:43 PM
AutoFill pattern based on cell locations valoo Excel Discussion (Misc queries) 4 July 28th 06 09:39 PM
How do I change color pattern based upon a formula within a cell? aemuk Excel Worksheet Functions 1 June 16th 06 11:18 PM


All times are GMT +1. The time now is 10:02 AM.

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

About Us

"It's about Microsoft Excel"