I'm not able to open file with filename in Chinese character. It hit runtime error 1004 with following messages:
Sorry, we couldn't find C:\Users\My\Downloads\Data\?????.csv. Is it possible, it was moved, renamed or deleted". I have Chinese font been installed in both Window and Excel. What is the possible root cause for this problem ?
Here is the code I'm using:
Sorry, we couldn't find C:\Users\My\Downloads\Data\?????.csv. Is it possible, it was moved, renamed or deleted". I have Chinese font been installed in both Window and Excel. What is the possible root cause for this problem ?
Here is the code I'm using:
VBA Code:
[/
Path = "C:\Users\My\Downloads\Data\"
Filename = Dir(Path & "*.csv")
Do While Filename <> ""
Workbooks.Open Filename:=Path & Filename, ReadOnly:=True
For Each Sheet In ActiveWorkbook.Sheets
Sheet.Copy After:=ThisWorkbook.Sheets(1)
Next Sheet
Workbooks(Filename).Close
Filename = Dir()
Loop
CODE]