View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default RunTime Error (Automation Error)

http://support.microsoft.com/default...;en-us;Q306518
INFO: Troubleshooting Guide for 80004005 Errors in Active Server Pages and
Microsoft Data Access Components

http://www.google.com/search?hl=en&q...=Google+Search

--
Regards,
Tom Ogilvy


"KD" wrote in message
...
Hi,

I have written some vba code that picks up data from an
excel worksheet and creates a new PowerPoint presentation
with the data. The only problem I seem to be getting is
that sometimes (and at different places) I generate a run-
time error. The full error message is as follows :

"RunTime Error '-2147467259 (80004005)' Automation Error"

Asd I said this appears at different places when running
the same macro on the same set of data. Can anyone help
me as it is very frustrating as I cannot really test the
code fully !

Many thanks
KD