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:
Bookmarks