How to copy a sheet with polish letter in name [VBA]?

134 Views Asked by At

I need to copy sheet from one workbook to another workbook. That is simple, but name of this sheet contains a polish letter "ł".

I know I have to replace "ł" with " & ChrW$(&H142) & ", but have no idea how to build a name of sheet that VBA will find.

Let say that the name of sheet that I want to copy is "masło"

Part of code should be

x.Sheets("masło").Copy After:=y.Sheets("examplesheetname")

How do I write the word 'masło' so that VBA finds that unfortunate 'ł'?

0

There are 0 best solutions below