+ Reply to Thread
Results 1 to 3 of 3

How to modify a VBA to place all data on one page instead of a new page each query

  1. 11-15-2013, 03:05 PM #1
    PistachioPedro
    PistachioPedro is offline
    Registered User
    Join Date
    10-26-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2016
    Posts
    56

    How to modify a VBA to place all data on one page instead of a new page each query

    Hello! Please help me, this is the code I have so far which I have found online.

    Please Login or Register  to view this content.
    The only modification I have made is change the WebTables and the target URL. How can I edit this so that each new page query will add the returned data on the same sheet, underneath the previous page?

    As it is now it creates a new worksheet for every page query. Thanks!
    Reply With QuoteRegister To Reply
  2. 11-17-2013, 01:45 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,047

    Re: How to modify a VBA to place all data on one page instead of a new page each query

    This gets them all on the same worksheet.

    Please Login or Register  to view this content.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 11-17-2013, 01:56 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,047

    Re: How to modify a VBA to place all data on one page instead of a new page each query

    Slight refinement. Every 36 rows and fit to page width.

    Please Login or Register  to view this content.

    Regards, TMS
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Any help greatly appreciated! (Drop down lists data entry page -> Formatted results page)
    By limebaish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2012, 12:03 PM
  2. Import data from web page- I cannot use direct function as web query.
    By manmehdiam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-01-2012, 07:09 PM
  3. [SOLVED] Web query to download web page data to excel in text format
    By panditji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2012, 12:30 AM
  4. Web Query and Page Source - Importing Data
    By exc4libur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2011, 11:52 AM
  5. Query for data from a web page
    By i2trader in forum Excel General
    Replies: 3
    Last Post: 10-27-2009, 02:42 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1