Hi,

I'm building a macro that takes various data off one sheet and places it onto another. The last line of code is where I'm having problem. The name of that file ("01-10-07 Freight Details") will change every week depending on the date. I don't want to have to change the macro every week. What would I write the macro would go to whatever other open workbook there is after it opens the first one?


Workbooks.Open(Filename:= _
"S:\malone\Journal Entries\Journal Entry Templates\LCI template.xls", _
UpdateLinks:=0).RunAutoMacros Which:=xlAutoOpen
Windows("01-10-07 Freight Details.xls").Activate

Please let me know if you need any more information.]

Thanks in advance,

Eddie.