Rename a varying table name

[DJDRU]

Hello again,

Initially I am importing a sheet from a downloaded document and the name is "owssvr(#)" where the # changes based on the version. I am able to rename this sheet with no issue. The problem is the table name may change as well and the name of the table is not consistent.

Question: What code can I use to rename a table to just "Table" every time when running my code regardless of what the name was originally?

This is the only table in the workbook.

Thanks!
Drew

Please Login or Register  to view this content.

[Ron Coderre]

Something like this should work:

Please Login or Register  to view this content.

Is that something you can work with?

[DJDRU]

Thanks for the help! All is well now.

D