Hey everyone... Looking for some help on this one.. I'm trying to perform a web query that pulls a table from our companies intranet. I'm able to manually do this each day... however, the Url that my company uses is:
http://www.companywebsite.com/cctpta...=KS7561&sDate=7/24/2013&mgrID=RE4832&hrchy=KS7561,RE4832,JG1819,VJ1963®ion=-1&ordStatus=-1&mtd[0]=9830.00&daily[0]=212.00&mtd[1]=241767.00&daily[1]=10069.00&mtd[2]=0.00&daily[2]=0.00&mtd[3]=3528.00&daily[3]=0.00&mtd[4]=2506.00&daily[4]=0.00
The problem is, the date updates each day. The rest of the URL is the same... just the Date changes. To have this pull every day..right now, i'm manually changing it.. (If only the company would label the dropdown "today"..).
Anyway... I know there's a way to have this update..I'm just too new to VB to program it... Any tips would be GREAT! Thanks everyone!
Bookmarks