I am using MS office 2000. I use query to import a list of client names and their individual contract numbers from an a billable report which is in a separate excel spreadsheet.
EX:

15 ABC
30 Group
12 Joe Smith Co.

I then take this info and put it into a chart. My problem is that each new week, I create a new billable report worksheet. Currently my query data is coming from 071407 but now I want it to come from 072807 and so on and so forth. How can I change this? (And if so, automatically would be great). Thanks!

Here is the way

Assuming you have spreadsheet corresponding to the date

Sub Dynamic_Query()

Dim sTabName As String
Dim sXS As String
Dim sQuery As String

sXS = CStr(Format(Date, "mmddyy"))
sTabName = "[" & sXS & "$]"
sQuery = "Select * From " & sTabName & ";" '

End Sub
")

http://www.dotnetdud.blogspot.com

I'm sorry I don't think I was clear, I meant in a different workbook, not spreadsheet. Will this still work??