Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Rick and JLGWhiz. I think Rick has better solution to suit my
requirement. I will definitely give it a try. For the moment, what I am trying to do is For i = 1 To 15 ActiveWindow.ActivateNext If Right(ActiveWorkbook.Name, 18) = "_practice.xls" Then File_Name = ActiveWorkbook.Name End If Next i The assumptions here are a.) not more than 15 files are open in the excel session and b.) no file other than the file I desire has a suffix of "_practice.xls". The latter assumption, I guess, is valid for Rick's code as well. Still I think his methodolgy and approach is much more sound than mine. Thanks a lot! Best Regards, Abhijat. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
attempting to format a color pattern in tab 3, based tab 2 and tab | Excel Discussion (Misc queries) | |||
How do I Propogate Cell Selection Pattern? | Excel Worksheet Functions | |||
Selection Window | Excel Discussion (Misc queries) | |||
AutoFill pattern based on cell locations | Excel Discussion (Misc queries) | |||
How do I change color pattern based upon a formula within a cell? | Excel Worksheet Functions |