Hey Zach,

Shoot. I was hoping that might do it.

.......what if you tried to explicitly call out Windows using Application before it:

[vba]
Application.Windows("" & ReportName & " ").Activate
[/vba]
And the same goes for the line below:
[vba]Application.Windows("oldreport.xls").Activate [/vba]
Again, long shot...but maybe

Hope it works

EDIT: Also, if there's supposed to be a single quote before ReportName, shouldn't it be:
[vba]
Application.Windows("""" & ReportName & " ").Activate
[/vba]
Try that too.