Excel gurus! Need some help (displaying a webpage in excel)

Discussion in 'Computers' started by Michael D. Bunting, Aug 17, 2006.

  1. Michael D. Bunting

    Michael D. Bunting Screenwriter

    Joined:
    Jun 9, 1999
    Messages:
    1,828
    Likes Received:
    0
    Trophy Points:
    0
    Real Name:
    Michael
    Any Excel gurus out there? [​IMG]

    I need to have a specific web page automatically display after opening up an excel file.

    I have previously accomplished something similair (displaying a web image) - but cannot for the life of me figure out how to have an entire web page display automatically.

    Any help or guidance is much apreciated!

    Mike
     
  2. SethH

    SethH Cinematographer

    Joined:
    Dec 17, 2003
    Messages:
    2,867
    Likes Received:
    0
    Trophy Points:
    0
    Are you having trouble displaying the webpage, opening it automatically or both?

    I'm not sure how to display the webpage. To open it automatically, though, you'll need to write a little VBA code. Go to Tools>Macro>Visual Basic Editor. On the left-hand side of the screen click on "This Workbook". A new window should appear on the right side of the screen. This new window should have two drop-down menus at the top. In the first menu, select "Workbook", in the second menu select "Open".

    This will give you a place to write all the commands you want to happen when you open the workbook.

    If you need help with the VBA, then feel free to ask some specific questions. I'm a little rusty, but might be able to figure some things out for you.
     
  3. Rommel_L

    Rommel_L Second Unit

    Joined:
    Apr 25, 2000
    Messages:
    355
    Likes Received:
    0
    Trophy Points:
    0
    Something like this?
     

Share This Page