View Single Post
  #1   Report Post  
Jamie
 
Posts: n/a
Default Using Wildcards in Sheet selection

Hi There

I need to run one macro for 5 slightly different named spreadsheets.

At the moment, as I'm copying pivot tables between two spreadsheets I have a
few lines like this:

Windows("Extra Triangles - MOT.xls").Activate

I have 4 other sheets that I want to use the same Macro on called

Extra Triangles - AMO.xls
Extra Triangles - INT.xls
Extra Triangles - CAR.xls
Extra Triangles - ALL.xls

Is there a way I can change this line to just activate any spreadsheet that
begins with - Extra Triangles?

Any help would be greatly appreciated.

Thanks in advance

Jamie