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 'ł'?