+ Reply to Thread
Results 1 to 1 of 1

VBA - Update Legacy Web Query Connection String

  1. 06-16-2021, 06:40 AM #1
    Josephrandall
    Josephrandall is offline
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    VBA - Update Legacy Web Query Connection String

    I have a web query that loads weather data from a site. I would like to be able to reference a cell to retrieve the web address. example - sheet1 cell a1

    Can this be done?
    Attached Images Attached Images
    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. Automatically update connection for Table Query on Opening/Saving Workbook
    By MandersDiva in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2020, 04:05 PM
  2. Excel Macro to Update Connection String when Path and/or Filename Changed
    By MandersDiva in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2020, 05:27 AM
  3. Power Query from CSV - possible to move connection string to excel without MS PQ?
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2016, 04:35 AM
  4. VBA Change WSID in Connection String for Query Table
    By KMJG in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2014, 02:03 PM
  5. Connection string for MS Query
    By kravi88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2014, 12:41 PM
  6. Connection string for MS Query
    By kravi88 in forum Access Tables & Databases
    Replies: 0
    Last Post: 06-05-2014, 10:42 AM
  7. Using Macro to Reset MS Query Connection String
    By KyleForgie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2014, 07:34 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