I am familiar with VBA, but this one has me stumped! Basically, I want to have Excel fill out an Aspx form, submit it, and then pull in the data from the html table that the form produces. There are multiple queries it would have to do, so I would want it to loop through until it is done with my list of inputs. Is this possible?!? I don't even know where to start. The website I need to pull data from is: On the form, there are multiple fields, but the one I am interested in is the 'Study Area Code.'
- When you right-click an html document (.html) and open as 'Excel', Excel will open up and retain the html appearance in the sheet. I am trying to write VBA code to import an HTML file (.html) into the worksheet while retaining the HTML look. (I do not want the html code to appear in the sheet).
- Feb 13, 2006 For all general questions relating to Excel but not including VBA or formulas.
On this page you find some basic VBA code to Import and Export VBA code in Excel for Windows. You can use it to import modules/userforms to other Excel files or to.
An example input I would have in this field is '529910.' I would have a different sheet in my workbook with all the SACs I need to pull. My vision for the end result is to have all the data pulled into one sheet. Can anyone give advise/help?
Thanks, Matt. So, my vision of this would be to have a sheet, maybe just 'sheet1' for now, hold a list of the SACs I am wanting to query using your code. They would be listed in A2 - A###. Then in another sheet, 'sheet2' for now, when I run the VBA, I would want it to go through the different SACs in sheet1 and pull the data into sheet2. There is no set number rows of the html table.
Html File Download
It is going to be growing each month. I think your code already pulls everything in the table.
When it loops back through for the next table, I would want it to pull just the dataset, no header, and place it in the next available row. Does all of that make sense? Thanks again!