+ Reply to Thread
Results 1 to 5 of 5

Web Query (From Web function)

  1. #1
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Web Query (From Web function)

    I have a worksheet that pulls out the data from web directly through excel's "Get Data From web" functionality found on the Data tab - this part is now automated and automatically goes through a composed set of strings turned into a URL..
    no this code automatically regenerates that web query and one problem I'm getting now is that the number of connections present in 1 workbook is so great that it appears it has reached its limit (i dont know how many is the limit - but this workbook has about 400 connections present).

    so what i need now - is a macro that can Delete the web connections based on the name of the connection
    (there is one i need to maintain - for the logins)


    i went through the web for some search and tried recording. this came up
    Please Login or Register  to view this content.
    and somewhere in stack overflow they posted a code that loops through the queries but is referenced through the index, but what i need is the names
    don't worry, there's a lot of people that are far more confused than you
    but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,019

    Re: Web Query (From Web function)

    Following code works for me...
    Please Login or Register  to view this content.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  3. #3
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Re: Web Query (From Web function)

    that code does work, but i need it to loop through all the connections

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Web Query (From Web function)


    See For Each statement in VBA help …

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,019

    Re: Web Query (From Web function)

    Try...
    Please Login or Register  to view this content.

+ 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. [SOLVED] query about VALUE function
    By Harlan Grove in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 02:05 PM
  2. query about VALUE function
    By gvm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. query about VALUE function
    By gvm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  4. query about VALUE function
    By gvm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2005, 08:05 PM
  5. [SOLVED] Microsoft Query rejects "nz" function in Access Query
    By Vaughan in forum Excel General
    Replies: 0
    Last Post: 05-04-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1