Hello,

I'm currently using the web query function to pull information from our company intranet. This problem that I'm running into is the Url that I'm using is a dynamic URL, meaning that it changes every day. An example of the website is below (I removed the actualy website as it contained company info):

http://www.companywebsite.com/cctpta...=JC509T&sDate=7/26/2013&mgrID=KS7561&hrchy=JC509T,KS7561,RE4832,JG1819,VJ1963&region=-1&ordStatus=-1

The only part of the URL string that changes is the date (I've highlighted in bold) the rest of the URL String stays the same every:
http://www.companywebsite.com/cctpta...=JC509T&sDate=7/26/2013&mgrID=KS7561&hrchy=JC509T,KS7561,RE4832,JG1819,VJ1963&region=-1&ordStatus=-1

Is there anyway that I can have the web query pull the date that I input into a cell (ex: A1 of Sheet 1) and have it update the web query url. This would save me a lot of time from going into the connection properties and manually changing the date to the date that I want pulled.

Any help would be GREATLY appreciated! Thank you!