Another department has a program that exports a report to xls which they
save. I'm helping them by building a macro that has them open this file to
use for a comparison against another file. Problem is, their system exports
the file with a bad sheet name and the code 'Workbooks.Open filename' won't
open it at all and just goes to debug. Anyone know a way around this so it
opens it?

I know they can open it manually, hit ok on the alerts, rename the sheet and
resave. But they aren't really that computer savvy and was hoping not to
risk it. Done it in the past that way and still get calls sometimes from new
users, was hoping to find solution to avoid it this time.