Use excel vba to scrape data to specify cell

Job ID: 34206080

Budget: $10 – $30 USD

Please create an Excel VBA to automate the following work:
1.Enter a date in excel cell B2.
2.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 the image 1.)
3.Download the specified date csv file which is entered before at step 1.(cell B2).(See the image 2.)
4.Copy and paste the specified range data to excel cell H2.(See the specified range at image 3. and image 4.)

5.It's no need to save the downloaded csv file after passing the data.

NOTE:If B2 is empty, dowload the newest csv file in the url.
Related categories: Visual Basic Excel Web Scraping