+ Reply to Thread
Results 1 to 4 of 4

Loop through list, perform web query and save each query on its own page

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    334

    Loop through list, perform web query and save each query on its own page

    I have the following code that does MOST of what I need it to do except it does not save each query on its own worksheet!

    The code runs each query from the list but it saves them side by side in one worksheet

    Using Excel 2010 and Win7 Pro
    Any help appreciated.


    Please Login or Register  to view this content.
    Last edited by anrichards22; 11-07-2012 at 07:49 AM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Loop through list, perform web query and save each query on its own page

    run macro step by step with F8 to see, otherwise attach a sample file for testing
    If solved remember to mark Thread as solved

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Change the Destination of the 2nd, and any subsequent queries.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    334

    Re: Loop through list, perform web query and save each query on its own page

    Thanks, problem solved!!

+ 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