I am trying to adapt a 2007 file to work in 2010. I just upgraded this PC to Win 7 and Excel 2010. The routine goes to a website and grabs a file each week. I then scrape the information I want and append it it to my local file. Now in Excel 2010, or maybe its Windows 7 doing it, I get a pop up message box warning me of harmful files. I tried putting sendkeys in to "OK" the message box but apparently the popup event happens before the sendkeys can be run. Any thoughts on how to handle the pop up?