Renaming and eligible charactrs

Hi Forum,

I am importing a lot of sheet via a CommandButton.
Would like to rename imported sheet with the filename from the imported workbook.

The naming convention for all workbooks which will be imported is something_anotherthing_2020
Due to the 31 character sheet limit i would like to only use this part something_anotherthing_2020when trying to rename the sheets. So everything before the first underscore.
I already have a suffix for each sheet so the filename will be to long if the whole filename is used.


WSNew1.Name = ActiveListWB.Name & " - report"
WSNew2.Name = ActiveListWB.Name & " - Pr"

Moreover is it possible to delete non eligible characters when during this e.g. some&thing = something

Thanks in advance

Hi Sweep,

I have a bit of a difficulty understanding where to attach the newname oldname split?

Please Login or Register  to view this content.

ohh of course was not following the syntax correctly.
thanks