I'm trying to find a way to pull data from a webpage that is embedded in a VBA userform. The only access to the webpage is through the userform so building a webquery in Excel will not work. I've tried various strings of coding, but with no actual website other than that in the userform, I cannot get them to work. Does anyone have any ideas that could help me out? Specifically I need to pull a table from the embedded website and input it into Excel Using VBA to insert current active VBA based webbrowser into Excel spreadsheet
This is what I have so far. I have a userform that opens a webpage, within the userform itself, which you insert the desired information into and it gives you a table of results. What I'm wanting to do is have a command button that, when pressed, transfers the current table in the userform contained webpage to an excel worksheet. Now a twist, I need each time the button is pressed for the table to be input into the next available worksheet. Each worksheet has a set of equations built in that automatically generates a report on a seperate worksheet. The biggest part I'm looking for is to pull the table from the userform contaiined website, it was how I was asked to build it, into the excel document itself. The rest is fluid and I can change. Any help you can provide would be appreciated.
Bookmarks