Renaming Different Worksheets with the Same Macro

[sazi22]

I have a macro that will run on many different .csv files. The worksheet in each file is named as the file. I want it named "ABC" in all files.

What code can I use to rename the worksheet in each file even though all the worksheets have different names?

Thanks,

 

[SkipVought]

Hi,

Have you tried turning on your macro recorder an recording actually doing what you want to do?

Try that and then post back with your code.

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]