I am using a variant of the calcpos application. When I open excel with the VBA code and run the program, I get the lat and long for a specific address. However when I run it again. I get a run-time error 2147467259 80004005 - automation error message. Oddly enough, if I select the code in VBA and copy and paste it back. I can run the program again and it works. It seems that the copy and paste is clearing out the buffer and replacing it with whatever I copy and that causes the program to work again - but only once. Any ideas on how to fix this?