+ Reply to Thread
Results 1 to 1 of 1

Pull Data from a Webpage Embedded in a VBA Userform

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    7

    Pull Data from a Webpage Embedded in a VBA Userform

    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.
    Last edited by heolink2006; 04-02-2013 at 03:37 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1