ExcelBanter - Return name of current worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Return name of current worksheet (https://www.excelbanter.com/excel-programming/430595-return-name-current-worksheet.html)

Newbie_nick

Return name of current worksheet

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

Bob Phillips[_3_]

Return name of current worksheet

Activesheet.Name = "Raw data"

--
__________________________________
HTH

Bob

"Newbie_nick" wrote in message
...
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

All times are GMT +1. The time now is 04:41 PM.