Good evening Orson100

I saw your post earlier, and as I don't have Excel 2010 I'm probably not the best person to answer, but ...

Ivan F Moala has a couple of routines here that should help out. However, he gives two options to do it ; a VBA method and an API method. With Excel 2010 you would need to avoid the API method - I won't go into why, I'll just tell you now it almost certainly won't work. There should be no reason why the VBA method would fail.

HTH

DominicB