Closed Thread
Results 1 to 3 of 3

Using VBA to insert current active VBA based webbrowser into Excel spreadsheet

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

    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.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Using VBA to insert current active VBA based webbrowser into Excel spreadsheet

    Hi and welcome to the forum

    is this the same thing as what you are asking on this thread?

    http://www.excelforum.com/excel-prog...-userform.html

    If so, please do not post duplicate threads. If you are intending to add detail, add that detail to the 1st thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Using VBA to insert current active VBA based webbrowser into Excel spreadsheet

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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