Originally Posted by
Kenneth Hobs
That's a new one for me. I guess if you attach a file with one sheet named that way, I can test it. You can try copying the text in the tabname and try save some simple file not a notepad with that name. I suspect that Windows will not allow it.
So, the answer might be to translate those strings to the language of your operating system's regional settings. Mine is English so that is all I could really test. If your test finds the file naming to be the problem, and you like this idea, we can look for a way to do it. It could be coded to add a prefix like, Chinese-EnglishSheetNameHere.xlsx.
Sorry for can not attaching the sample file, but what i solved is set that Chinese into a column on Range Excel and pass it, but now I need help on dynamic that Chinese into this code, I try out and fails.
Dim get_value as String
get_value = ThisWorkbook.Sheets("main").Range("B8").Value 'B8 value stands for "環模".
Sheets("search").Range("C3").Offset(0, i - 1).Formula = "=INDEX('" & path & "[" & filename & "]" & get_value & "!$A:$O,MATCH(CONCATENATE(B3,E3,F3),'" & path & "[" & filename & "]*" & get_value & "'!$O:$O,0)," & i + 2 & ")"
The variable get_value if I set not dynamic then it works perfectly on my PC, but other is sometimes not. I want to dynamic it to formula to get value.
Can you give me a solution without workbook sample. Thank so much!
EDIT_FINAL: I have just solved.