VBA Workbook and worksheet with chinese naming

[joan1211]

Hello, I would like to ask if there is a way to set and call a Chinese workbook and worksheet? Thanks.

 

[yky]

I tested the following code. It worked. The workbook was successfully opened and the sheet activated.

Sub test()

Dim wb As Workbook

Set wb = Workbooks.Open("C:\temp\試試看.xlsx")

wb.Sheets("第二頁").Activate


End Sub