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!
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!