Visual Basic Code Update

Please see the attached picture for your reference.

I have this excel spreadsheet that check stock and current prices from multiple websites such as [url removed, login to view] and overstock.com. All you have to do is enter a URL from the appropriate supplier and click "Check Product". When the spreadsheet check the current prices from WalMart, it displays the price in US dollars which is what i want. However when check from a url from [url removed, login to view], it displays the current price in Canadian Dollars which is now what i want. I have tried using the spreadsheet on a virtual server and i have no problem at all and it displays US Dollars for www.overstock.com. However i do not want to use a virtual server. I want to be able to run the spreadsheet on my own computer and have it displays all current prices in US Dollars. The VBA is unlocked and you can have access to all of the source codes. All that needs to be done is find out why it gives me prices from [url removed, login to view] in Canadian dollars sometimes and change the appropriate code and make it display US dollars all the time. That is all that needs to be done. Do not change anything else with the spreadsheet. Please let me know if you need any more information. This project should be fairly easy and simple since all of the source code is already provided.

Excel Software Testing Visual Basic

Project ID: #6855907

About the project