developer help

currently i am working in store , we are working with website that give us the prices of the products i have created a another website to store the prices the problem is when ever the price changes i have to manually enter it and we have at least 400 product ; i have managed to create a small Macro keeps repeating the same steps but <hat i want to do is getting the prices with a get request so i can fire up a function when ready any help ?

by dagdag via TBN