Thread: use only part of window name in a macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
  
Posts: 897
Default 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

Reply With QuoteReply With Quote