+ Reply to Thread
Results 1 to 3 of 3

How do I do a web query via VBA?

  1. #1
    Registered User
    Join Date
    07-15-2010
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    51

    How do I do a web query via VBA?

    The Excel spreadshhet does a web from MSN for stock data.

    How do I do the same with VBA.
    Not just page refresh, but use the url to download the data onto a sheet.

    anyone?
    Attached Files Attached Files

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: How do I do a web query via VBA?

    Use the macrorecorder to find out.

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: How do I do a web query via VBA?

    That macrorecorder won't follow your steps outside of the application.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ 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