Open file-Copy data from and XLSX to xls document

Try:

Please Login or Register  to view this content.

Hopefully, Olly's suggestion works for you.
But here is a way to auto-convert your xlsx file to xls
ChosenName does not require an extension.
Amend myPath and myFile to match your requirements


1. put code below in a general module in a workbook
2. open file "Zip to county to Region.xlsx"
3. run the code

Please Login or Register  to view this content.

Originally Posted by 3345james

Opens the workbook but doesn't copy data to open workbook named
like "Excessive*.xls"

Are you putting (and running) the code in the "Excessive*" workbook, or in another workbook?

If it's in another workbook, then we need to change this line:

Please Login or Register  to view this content.

You said the workbook is "named like Excessive*.xls"

So try changing the code to:

Please Login or Register  to view this content.

I've highlighted the changes in red.

No attachment?