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
|