Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use only part of window name in a macro
How would you use only part of the window name in a macro, the dates will
change so I only need to use Time Sheet For Windows("Time Sheet For 09.18.2008 To 10.01.2008.xls").Activate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
use only part of window name in a macro
You could do something like this
Dim myWB As Excel.Workbook For Each myWB In Application.Workbooks If myWB.Name Like "Time Sheet For*" Then Windows(myWB.Name).Activate Exit For End If Next myWB -- HTH, Barb Reinhardt "Paul B" wrote: How would you use only part of the window name in a macro, the dates will change so I only need to use Time Sheet For Windows("Time Sheet For 09.18.2008 To 10.01.2008.xls").Activate |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
use only part of window name in a macro
What are you trying to do? Maybe if you state what your goal is, we
can assist you better. --JP On Sep 22, 4:05*pm, "Paul B" wrote: How would you use only part of the window name in a macro, the dates will change so I only need to use Time Sheet *For Windows("Time Sheet *For 09.18.2008 To 10.01.2008.xls").Activate |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
use only part of window name in a macro
I am just wanting to arrange some windows like below, but the time sheet one
will change names Windows.Arrange ArrangeStyle:=xlHorizontal Windows("FF Time").Activate With ActiveWindow .Width = 765 .Height = 232.5 End With ActiveWindow.SmallScroll Down:=2 Windows("Time Sheet For 09.18.2008 To 10.01.2008.xls").Activate With ActiveWindow .Width = 765 .Height = 255 End With With ActiveWindow .Top = 260.5 .Left = 0.25 End With "JP" wrote in message ... What are you trying to do? Maybe if you state what your goal is, we can assist you better. --JP On Sep 22, 4:05 pm, "Paul B" wrote: How would you use only part of the window name in a macro, the dates will change so I only need to use Time Sheet For Windows("Time Sheet For 09.18.2008 To 10.01.2008.xls").Activate |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
use only part of window name in a macro
Just assign the changing filename part to a string variable. Then you
can change the variable without hard-coding the dates (and potentially having to change it every two weeks). Dim strDate As String strDate = "09.18.2008 To 10.01.2008" Windows("Time Sheet For " & strDate & ".xls").Activate --JP On Sep 23, 8:31*am, "Paul B" wrote: I am just wanting to arrange some windows like below, but the time sheet one will change names Windows.Arrange ArrangeStyle:=xlHorizontal * * Windows("FF Time").Activate * * With ActiveWindow * * * * .Width = 765 * * * * .Height = 232.5 * * End With * * ActiveWindow.SmallScroll Down:=2 Windows("Time Sheet *For 09.18.2008 To 10.01.2008.xls").Activate * * With ActiveWindow * * * * .Width = 765 * * * * .Height = 255 * * End With * * * * With ActiveWindow * * * * .Top = 260.5 * * * * .Left = 0.25 * * End With "JP" wrote in message ... What are you trying to do? Maybe if you state what your goal is, we can assist you better. --JP On Sep 22, 4:05 pm, "Paul B" wrote: How would you use only part of the window name in a macro, the dates will change so I only need to use Time Sheet For Windows("Time Sheet For 09.18.2008 To 10.01.2008.xls").Activate- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with part of my macro | Excel Programming | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Run only part of a macro for testing | Excel Programming | |||
Lookup as Part of Macro | Excel Programming |