Hi there,
Apoligies if this has been asked before....I have a workbook with multiple sheets in it that i am inputting a different csv. file into each one creating a table. Is there a way within my macro to rename my sheets as per what the table name within them is? Thanks heaps in advance, very new to this.
Brendon
Hi Brendon
Welcome to the forum...Not sure what code your are making use of...A snippet will need to be entered within somewhere...
This snippet as a separate module will rename each sheet to its Table within name...I assume each sheet has one table only...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thanks heaps that solved the problem perfectly!! Yip i just have just one table per sheet. Thankyou!!
Pleasure..Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks