I have this worksheet that will get some chinese stock live data from a webpage using web query
the website is http://quote.cfi.cn/quote_600515.html
When i input stock ticker name in sheet2 A1:A100, the vba will get the data and arrange as in sheet2.
Sheet1 I:M is the data that i manually arranged in Volume open high low close, with the chinese characters that needs to be removed. How can this be done using VBA, thanks in advance. (web query range is in sheet1 B:F)