Return name of current worksheet

N

Newbie_nick

I have data in numerous CSV files, and when I open them in Excel, the
worksheet name is the same name of the CSV file. Since I have numerous files
all with different names, I would like to write a macro to select the current
sheet and rename it as something generic like "Raw data". I'm sure that this
is an easy request, but I'm struggling with it!

thanks!
Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

switch to another worksheet, then return to original sheet 2
Rows outside of current range being saved as CSV 2
Want Macro to save to .xlsx 2
taking out all \/?*[] so input can be name of worksheet 7
Copy yellow shaded rows to another worksheet 2
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Copy PIVOT table? 5
Find Specific Rows in Range and Create New Tab 18

Top