There's Hope, Hooray!: Is this possible - Change dates in URL? Excel help response (18 Oct 2011)

First off Excel Helper, Thank You for such a quick response! I'm quite impressed.

I think out of your 3 suggestions, option 3 might be the most applicable.
Partly because I'm hoping such code could manipulate the dates among the various URL structures I'm dealing with.

Here are the 5 URL types I'm working with - hopefully you know of a way to execute one function or macro that will run on a spreadsheet with hundreds of such URLs. [In these examples I'd want to take the dates of the 13th and 14th and increment them by a day. For my 2nd need of pulling info for "tomorrow" then perhaps this is a function I can just apply twice to a second Sheet of these links.]

http://www.kayak.com/hotels#BEST-WESTERN-PLUS-Grosvenor-Airport-Hotel,San-Francisco,CA-c13852-h33965/2011-10-13/2011-10-14/2guests
http://www.expedia.com/San-Francisco-Hotels-Best-Western-Plus-Grosvenor-Airport-Hotel.h7635.Hotel-Information?chkin=10/13/2011&hashTag=roomsAndRates&chkout=10/14/2011&mdpcid=META.kayak.Meta.Hotel.multibook_unpriced.september2009test&rm1=a2&
http://www.booking.com/hotel/us/best-western-grosvenor.html?tab=1&error_url=%2Fhotel%2Fus%2Fbest-western-grosvenor.en-us.html%3Flabel%3Dgog235jc%3Bsid%3D60f01ceba1cbacb0afaf277680128c9f%3B&do_availability_check=on&label=gog235jc&sid=60f01ceba1cbacb0afaf277680128c9f&checkin_monthday=13&checkin_year_month=2011-10&checkout_monthday=14&checkout_year_month=2011-10
http://www.orbitz.com/shop/hotelsearch?type=hotel&hotel.type=keyword&hotel.keyword.key=San+Francisco%2C+CA%2C+United+States&hotel.locId=loc.id%3A4468&hotel.chkin=10%2F13%2F11&hotel.chkout=10%2F14%2F11&hotel.rooms%5B0%5D.adlts=2&hotel.rooms%5B0%5D.chlds=0&hotel.rooms%5B0%5D.chldAge%5B0%5D=&hotel.rooms%5B0%5D.chldAge%5B1%5D=&hotel.rooms%5B0%5D.chldAge%5B2%5D=&hotel.rooms%5B0%5D.chldAge%5B3%5D=&hotel.rooms%5B0%5D.chldAge%5B4%5D=&hotel.rating=&hotel.chain=&hotel.hname=Grosvenor&hotel.couponCode=&search=Search&hsv.showDetails=true&hotel.hid=22815&hotel.hkey=22815_null_null_null_A2:0
http://www.secure-res.com/res/vn4/avail.aspx?hotelid=708&checkindate=10/13/2011&nights=1&rooms=1&adults=2&children=0&childrenages=&trr=7FFFFFD90FDA62&culture=1&culturename=en-US&wtpid=dcs2nqpch00000cl0g9wzdd9o_9j3j

[This 5th URL doesn't show the "check-out" date, just the check-in date and 'nights=1'.]

Thank you so much.

There's hope, hooray!

Excel Help for There's Hope, Hooray! in Automating Data Analysis Tasks

There's Hope, Hooray!

	First off Excel Helper, Thank You for such a quick response! I'm quite impressed. I think out of your 3 suggestions, option 3 might be the most applicable. Partly because I'm hoping such code could manipulate the dates among the various URL structures I'm dealing with. Here are the 5 URL types I'm working with - hopefully you know of a way to execute one function or macro that will run on a spreadsheet with hundreds of such URLs. [In these examples I'd want to take the dates of the 13th and 14th and increment them by a day. For my 2nd need of pulling info for "tomorrow" then perhaps this is a function I can just apply twice to a second Sheet of these links.] http://www.kayak.com/hotels#BEST-WESTERN-PLUS-Grosvenor-Airport-Hotel,San-Francisco,CA-c13852-h33965/2011-10-13/2011-10-14/2guests http://www.expedia.com/San-Francisco-Hotels-Best-Western-Plus-Grosvenor-Airport-Hotel.h7635.Hotel-Information?chkin=10/13/2011&hashTag=roomsAndRates&chkout=10/14/2011&mdpcid=META.kayak.Meta.Hotel.multibook_unpriced.september2009test&rm1=a2& http://www.booking.com/hotel/us/best-western-grosvenor.html?tab=1&error_url=%2Fhotel%2Fus%2Fbest-western-grosvenor.en-us.html%3Flabel%3Dgog235jc%3Bsid%3D60f01ceba1cbacb0afaf277680128c9f%3B&do_availability_check=on&label=gog235jc&sid=60f01ceba1cbacb0afaf277680128c9f&checkin_monthday=13&checkin_year_month=2011-10&checkout_monthday=14&checkout_year_month=2011-10 http://www.orbitz.com/shop/hotelsearch?type=hotel&hotel.type=keyword&hotel.keyword.key=San+Francisco%2C+CA%2C+United+States&hotel.locId=loc.id%3A4468&hotel.chkin=10%2F13%2F11&hotel.chkout=10%2F14%2F11&hotel.rooms%5B0%5D.adlts=2&hotel.rooms%5B0%5D.chlds=0&hotel.rooms%5B0%5D.chldAge%5B0%5D=&hotel.rooms%5B0%5D.chldAge%5B1%5D=&hotel.rooms%5B0%5D.chldAge%5B2%5D=&hotel.rooms%5B0%5D.chldAge%5B3%5D=&hotel.rooms%5B0%5D.chldAge%5B4%5D=&hotel.rating=&hotel.chain=&hotel.hname=Grosvenor&hotel.couponCode=&search=Search&hsv.showDetails=true&hotel.hid=22815&hotel.hkey=22815_null_null_null_A2:0 http://www.secure-res.com/res/vn4/avail.aspx?hotelid=708&checkindate=10/13/2011&nights=1&rooms=1&adults=2&children=0&childrenages=&trr=7FFFFFD90FDA62&culture=1&culturename=en-US&wtpid=dcs2nqpch00000cl0g9wzdd9o_9j3j [This 5th URL doesn't show the "check-out" date, just the check-in date and 'nights=1'.] Thank you so much.
	Posted by DMKPDX on 18 Oct 2011