hi all,
i am trying to rename an excel sheet, several actually as it will be in a loop, to the parameter mcusname but i have tried a lot of different ways without joy. i have included a few examples so you can see what track i was going down, anyone any idea whats going wrong?

OleApp.Sheets("Sheet1").Name = "mcusname"
OleApp.Sheets("Sheet1").Name = &mcusname
OleApp.Sheets("Sheet1").Name = ("mcusname")
OleApp.Sheets("Sheet1").Name(mcusname)

Slán
~M