+ Reply to Thread
Results 1 to 3 of 3

VBA Web query

  1. #1
    Registered User
    Join Date
    09-12-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    23

    VBA Web query

    Hello all,

    I'm trying to use VBA to download data from the web.

    The Macro goes like this :

    Please Login or Register  to view this content.
    This macro downloads infos about model 1858 in a table starting in Cell "A1".

    Let's say that I have models 1858 to 1865 And I want information about model 1859 to be downloaded in cell A50
    information about model 1860 to be downloaded in Cell A99

    How do I change the macro ?
    Thank you very Much
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: VBA Web query

    I just made a For..Next loop from 1858 to 1865. The value of i is concatenated into the strings, and the destination is expressed as "$A$" & 1 + x, with a loop to increase x by 49 per cycle.

    Please Login or Register  to view this content.
    Last edited by daffodil11; 09-12-2016 at 02:45 PM.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    09-12-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    23

    Re: VBA Web query

    Quote Originally Posted by daffodil11 View Post
    I just made a For..Next loop from 1858 to 1865. The value of i is concatenated into the strings, and the destination is expressed as "$A$" & 1 + x, with a loop to increase x by 49 per cycle.

    Please Login or Register  to view this content.
    That completely solved the issue.

    Thank you very much for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-22-2016, 05:14 PM
  2. Understanding Query Design with respect to building an Append Query
    By swade730 in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2016, 01:00 PM
  3. Replies: 1
    Last Post: 09-08-2015, 08:12 PM
  4. Replies: 2
    Last Post: 02-01-2013, 04:21 PM
  5. [SOLVED] Loop through list, perform web query and save each query on its own page
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 07:50 AM
  6. Problem with selecting range with in query table after query refresh
    By shooter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:55 AM
  7. Web Query - Change a word in query to form a new query
    By scottymelloty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 04:13 AM

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