Windows 7 security causing a problem, and code needed to delete .csv file.

[Johnboy2]

Hi people, I hope there is someone here that can help with my two problems. The first one is this. I have a workbook with a hyperlink to a Yahoo, up to the minute, currency rate of exchange, site. The latest R.o.E is downloaded, the code then copies the data, and pastes it into my workbook. Everything works fine in Excel 2003 but when the wb is used in Excel 2007, when the hyperlink is activated, a "Windows Security" dialogue box appears asking for a password. If I click on "Cancel" the download hangs for about 15 secs, and then continues and completes. Firstly, is there a way, using code, that this message can be bypassed or, failing this, what password is being asked for? I need this info because my wb will be used by other people, and will lead to confusion if they are using Excel 2007.
My second problem is that, when the download has finished, I need some code that I can add to the bottom of the download code, that will close or delete the .csv file that has downloaded and minimized in the taskbar. The reason for this is that, if the .csv file is still in the taskbar and a second download be required later on, the first downloaded .csv file blocks it and stops the second one. I have attached a simplified version of my wb which can be tried, and the problems seen, by anyone that feels they may be able to help.
Thanks in advance to any helpers.
Cheers, John.