Hello, I just asked a question this morning about opening/refreshing two Excel sheets, imprting them to two seperate Access tables, overwriting the data in these tables, and closing the Excel file.

I am getting an error message when the macro is ran that says

"Sheet1" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

I checked all columns in the Excel file, there are no invalid characters or blank cells.

What are all possible causes for this error message and how can it be fixed?

Thank you.