Activate window with a macro

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.

to goto the next open workbook use

Please Login or Register  to view this content.

Thank you so much for your replies. Sorry I haven't been able to get back to until now.

Eddie.