Hi, Heather-
Instead of this line:
Windows("ImportFile").Activate

....try this:
Windows(ImportFile & ".xls").Activate

Did you post the entire macro? What are you trying to do? There may
be additional code involved if you're trying to specify a location and
filename to open.

Dave O