Importing a single sheet from another Excel file with or without table formatting

[mantis1117]

The following code works fine if the sheet being imported is formatted as a table, and the table is renamed. What I am trying to do is import the sheet no matter if it has table formatting or not, rename the table if it does, make a table and rename it if it doesn't.

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[mantis1117]

Fluff13, you are awesome! Simple fix and works great! Now this is almost entirely idiot proof for my supervisor who has no idea on how to do any of this. Thank you!

[Fluff13]

Glad to help & thanks for the feedback.

PS re

Now this is almost entirely idiot proof

Don't you believe it. eejits will ALWAYS find a way.

[mantis1117]

Haha, yeah. You're right because we say, "How did they do that?"