Web scraping with Excel VBA(Do Not use python) -- 2
Budget: $30 – $250 USD
Please create an Excel VBA to automate do the following work.
Enter date data in excel cell A1.(ex:20220722,the year should be 2022-1911=111)
Go to an url(http://www.tpex.org.tw/web/bond/tradeinfo/cb/CBDaily.php?l=zh-tw) and choose the Year and Month and select the bottom option.(See image 1.)(image B2 should be A1)
Download the specified date csv file which is entered before at step 1.(cell A1).(See image 2.)NOTE：If cell A1 is empty, download the newest csv file in the url.
Copy and paste the specified range data to excel cell B2.(See the specified range at image 3. and image 4.)
There's no need to save the downloaded csv file after passing the data.(Do not create any new tab to scrape the data)
Enter date data in excel cell A1.(ex:20220722,the year should be 2022-1911=111)
Go to an url(http://www.tpex.org.tw/web/bond/tradeinfo/cb/CBDaily.php?l=zh-tw) and choose the Year and Month and select the bottom option.(See image 1.)(image B2 should be A1)
Download the specified date csv file which is entered before at step 1.(cell A1).(See image 2.)NOTE：If cell A1 is empty, download the newest csv file in the url.
Copy and paste the specified range data to excel cell B2.(See the specified range at image 3. and image 4.)
There's no need to save the downloaded csv file after passing the data.(Do not create any new tab to scrape the data)