Hi all and thank you in advance for any assistance. I'm in over my head on a project and looking for some help/guidance.
I want to pull information from a website based upon the information input into my worksheet.
A1 = OriginZip
A2 = DestinationZip
A3 = Zone
When zip codes are entered in to B1 and B2, run the vba script to this url http://www.fedex.com/ratetools/RateToolsMain.do?method=SetupFindZones entering the zip codes and retrieving and entering the resulting zone in B3.
I'm currently watching this youtube tutorial (https://www.youtube.com/watch?v=7sZRcaaAVbg) but I'm stumped because in the tutorial it is easier to grab the info by url ..?originzip=XXXXX
Any help or guidance would be greatly appreciated. I'm not terribly familiar with the visual basic editor but I know how to navigate to it and know some basics.
I want to pull information from a website based upon the information input into my worksheet.
A1 = OriginZip
A2 = DestinationZip
A3 = Zone
When zip codes are entered in to B1 and B2, run the vba script to this url http://www.fedex.com/ratetools/RateToolsMain.do?method=SetupFindZones entering the zip codes and retrieving and entering the resulting zone in B3.
I'm currently watching this youtube tutorial (https://www.youtube.com/watch?v=7sZRcaaAVbg) but I'm stumped because in the tutorial it is easier to grab the info by url ..?originzip=XXXXX
Any help or guidance would be greatly appreciated. I'm not terribly familiar with the visual basic editor but I know how to navigate to it and know some basics.
