R
Reepicheep
I am importing table data from five different Excel workbooks, and
need to write a macro that finds/selects a table that is named,
without knowing its name. I don't want to manually open each workbook
and change the table name.
The table named is ever changing, as this data is from an outside
source, and may be "Table_1", "Table_3", or "Table_1", in that order.
It's not logical.
However, I do believe that I can rely on the first part of the named
table always being "Table"....I do not know the number that comes
after.
Thank you for your help!
need to write a macro that finds/selects a table that is named,
without knowing its name. I don't want to manually open each workbook
and change the table name.
The table named is ever changing, as this data is from an outside
source, and may be "Table_1", "Table_3", or "Table_1", in that order.
It's not logical.
However, I do believe that I can rely on the first part of the named
table always being "Table"....I do not know the number that comes
after.
Thank you for your help!