Drawing Data from Multiple Spreadsheets

[HamiTipene]

Hi,

I need to draw data from weekly sheets spanning over a number of years. It is outflow data that can be found in the same format in each sheet. The problem is that each sheet is in different directories sorted by week and year. It is logical (directories are named by year, with subdirectories Week0108-Week5208). I am a little unfamiliar of how to open sheets by name. Could someone provide a start on how I might accomplish this task?

 

[texasalynn]

here is an example

Sub WeeklyFile()
Dim wFilename As String
Dim WkNO As String, CYr As String

WkNO = Format(Weeknum(Date), "00")
CYr = Format(Date, "yy")

wFilename = "Week" & WkNO & CYr
Workbooks.Open wFilename

End Sub