I've been tasked to create a VBA userform, which has been created, that contains a web page, already done with that part, that when a command button is pressed will insert part of the information from the webpage into an excel document. Each button push will need to send data to the next workbook. I tried to solve this by using just a regular xcel spreadsheet with the import commnand. The issue with that was the website has a dropdown that has results from different dates, after selecting the first date, the webpage address goes back to the original search page address, but it still shows results, but when the button was pushed in excel it imported the blank search page. My next step is to try and scrape just that portion of data that I need from the Website contained within the VBA userform. Is there any help that anyone can give me to get started?
Bookmarks