editing a portion of a web based connection daily

Ace Vendetta1

New member
Joined
Jan 22, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
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!
 
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.

Regards
Paul
 
Back
Top