View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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