Results 1 to 2 of 2

Thread: editing a portion of a web based connection daily

  1. #1
    Neophyte Ace Vendetta1's Avatar
    Join Date
    Jan 2019
    Excel Version
    Excel 2016

    editing a portion of a web based connection daily

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all!

    I have a question that i am trying to figure out. i have read online, but i likely just dont know the name of the action i am trying to do, and therefore can't find any answer

    I have a web based connection that is pulling a table off of a web page. the connection works fine. in the connection, it has a specific date in the address bar. i would like to know how to make that date adjustable without going into connections each time to update it. i thought there was a way (something like.. replacing the date in the query with < > ) and then having that route to a certain cell in a sheet, but for the life of me i can't figure out how to write it properly.

    for an example, the address of the web connection contains this part:

    "&startDateDay=2019%2F01%2F21" referring to 01/21/2019.

    any help with this would be very much appreciated!

    Thank you Guru's!

  2. #2
    Conjurer Paul_Christie's Avatar
    Join Date
    Mar 2016
    Nottingham, UK
    Excel Version
    Office 365 Monthly update
    Have you got Ken's book M is for (Data) Monkey? It's explained in Chapter 23. There may be something about elsewhere on this site but I can't find it at the moment. In any case i thoroughly recommend Ken's book.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts