How to close annoying popup windows with Excel macro?

Hello,

I am using the following basic macro which seems to work in getting currency exchanges rates from a website and populating them in my spreadsheet. However, I have 3 issues I require assistance with:

1. There are 3 annoying popup windows (1 in Internet Explorer, 2 in Excel) which I have not been able to find a solution for how to have my macro automatically close these (run the code and see for yourself). What code changes do I need to make to fix these issues?

2. How can I program my macro to automatically run every time I open my Excel file?

3. Is there any unnecessary code/improvements/optimization that could be done on my macro code (since I am not an expert programmer)?


I would appreciate someone sending me updated code that solves all my questions above.

My basic macro code:

Please Login or Register  to view this content.

KB7
unfortunately,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

What messages are you getting?