d4vem
10-24-2012, 11:02 AM
Hi All,
I have researched this problem endlessly without success so without expecting someone to do all the donkey work to resolve. I have tried lots of different methods but still arrive back to the initial issue. (So gladly share my experiences).
Objective
Extract prices (in this case Coffee retail prices) from retailers to C&C against (1) Coffee exchange Index prices
(2) Effect on subsquent retail prices
Issue
In the attachment there are two macros extracting data from Asda & Tesco (they are the same) the URLs are next to each button.
The URL's are OK when you copy and paste into Internet Explorer.
Asda is returning no data but Tesco is working fine. I have looked into HTML frames etc with no success.
Current Solution
Workaround is to do an Excel web query for Asda which is fine, but (and its happened) the URL may change and that means editing each of the queries (100+) where as updating a static list and dynamically running one macro based on content of table is fair more efficient.
Any assistance would be much appreciated, and I will gladly share any research I have already conducted.
Regards
David
I have researched this problem endlessly without success so without expecting someone to do all the donkey work to resolve. I have tried lots of different methods but still arrive back to the initial issue. (So gladly share my experiences).
Objective
Extract prices (in this case Coffee retail prices) from retailers to C&C against (1) Coffee exchange Index prices
(2) Effect on subsquent retail prices
Issue
In the attachment there are two macros extracting data from Asda & Tesco (they are the same) the URLs are next to each button.
The URL's are OK when you copy and paste into Internet Explorer.
Asda is returning no data but Tesco is working fine. I have looked into HTML frames etc with no success.
Current Solution
Workaround is to do an Excel web query for Asda which is fine, but (and its happened) the URL may change and that means editing each of the queries (100+) where as updating a static list and dynamically running one macro based on content of table is fair more efficient.
Any assistance would be much appreciated, and I will gladly share any research I have already conducted.
Regards
David