Thanks for the input, however the issue lies not in the actual syntax but in the way Excel 2002 opens and checks for errors on files.

Crystal Reports that have been exported to excel have messed up tab/worksheet names and excel 2002 automatically recognizes this fact and basically bombs out with code.

I tried opening it using various methods but it still checks for errors. My only option at this point is to export the report in a different format and copy in thru code to excel and continue my processing.

More code