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

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

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

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

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 -