I want to make a copy of the data on the web use vba to excel, to copy the contents of chongqing is always a color 120 issue of the data, http://data.shishicai.cn/cqssc/haoma/, to speed up the replication using paste text, first open the web page may be a new version, click on the old version, may after each open is the old format, you can copy, copy only 120 data, don't copy such as title, see the attachment, (copied down, after the second line might be advertising, can remove the better, can't post processing, because I can't find the website of the relevant data sources, so can only use this method to copy, late again processing,)
Thank you first BBS teacher give counsel, because can't preach attachment had to capture,

CodePudding user response:

CodePudding user response:

 
http://blog.csdn.net/a814153a/article/details/18214545