Reference system generated sheet names and change them with VBA

**ericbartha** · 12-15-2014, 05:03 PM

Hello everyone,

I tried finding this in the forums, but couldn't find a solution to my specific problem.

Anyways, I have a VBA script that opens up a workbook, does some formatting and calculations, saves the workbook as a new name and file type and then appends the data into an Access database. This works great except for the sheet names are not always exactly the same. They usually start the same, something like LWDJF102, but will follow with _RANDOM NUMBERS. I want a way to select the sheet name based on the first 8 characters. I tried using

Sheets("LWDJF019*").Name = "T_019_NonDeliveredShipments"

but that did not work. Any suggestions!? Thanks!!!

**protonLeah** · 12-15-2014, 06:46 PM

Please Login or Register  to view this content.

**ericbartha** · 12-15-2014, 06:48 PM

Thanks protonLeah!

I actually just made it work using ActiveSheet.Name = "T_019_NonDeliveredShipments" as there will always only be the one sheet. I came to reply, but you beat me to it!