sajanjiv
03-05-2009, 08:42 AM
I have an excel spreadsheet that needs to look at two separate cells for information, than go to a particular website and pull off information and put it onto the spreadsheet. There is also a timer involved as each item must be timed.
In this spreadsheet under macros there is already a macro written for it however it is not working so it either needs fixed or re written. THIS IS VERY IMPORTANT, the website I need the information from has an IP address shutdown if there is too much information taken off at a time so there is a timer written in to only pull off a item once every minute.
I need the spreadsheet to look at column “G” (Vintage) and “F” (Name) go to the website wwwdotwinesearcherdotcom pull of the information on the top 10 prices given and put them on the spreadsheet.
Column “X” shows the last update on the first line, “Y” through “AH” show the 1st 10 prices with the two cells below showing the name in the first below and the location on the second cell below.
You will also see in the code I need to start and stop from certain points.
ALSO PLEASE NOTE: this spreadsheet I am giving you is from an old 2003 version. Will it work on the 2007 version as well?
Thanks if you can help
Warm Regards
Sajanjiv
In this spreadsheet under macros there is already a macro written for it however it is not working so it either needs fixed or re written. THIS IS VERY IMPORTANT, the website I need the information from has an IP address shutdown if there is too much information taken off at a time so there is a timer written in to only pull off a item once every minute.
I need the spreadsheet to look at column “G” (Vintage) and “F” (Name) go to the website wwwdotwinesearcherdotcom pull of the information on the top 10 prices given and put them on the spreadsheet.
Column “X” shows the last update on the first line, “Y” through “AH” show the 1st 10 prices with the two cells below showing the name in the first below and the location on the second cell below.
You will also see in the code I need to start and stop from certain points.
ALSO PLEASE NOTE: this spreadsheet I am giving you is from an old 2003 version. Will it work on the 2007 version as well?
Thanks if you can help
Warm Regards
Sajanjiv