Run-time error '-2147467259 (80004005)

[3x0dus]

Hi everyone,

I was wondering if you could help me. I know very little about excel and macros, but I am trying to create a macro that will auto-populate a web form based on the text that appears in specific cells. I found a video on youtube that does just this, but I keep coming up against Run-time error '-2147467259 (80004005) - Method 'Document' of object 'IWebBrowser2' failed. For background, this is auto-populating on a corporate intranet webpage.

Here is my code:

Please Login or Register  to view this content.

----

So, two questions:

1. How do I resolve this error so that the macro works?
2. There are multiple text fields that are being auto-populated, not just a1 - do I add the same statement multiple times

Please Login or Register  to view this content.

and replace the cell number (a1 in this case)?

Also, if this method is incorrect and you know of an easier way to make this work, please feel free to share that with me, it's greatly appreciated!

Thanks in advance for your help!

[dangelor]

Not sure if it helps but a quick google search seems to show instances of that error means something is locked / not accessible / in use by another...