Macro to Autofill Internet Explorer Form

Hi Everyone,

I am new to this forum and to VBA. I am working on a macro to autofill a webpage form in internet explorer but am getting the below error message:

"Method 'Document' of object 'IWebBrowser2' failed"

I have looked around for solutions but have not been able to find anything. Below is the code that I have, any help would be much appreciated!

Please Login or Register  to view this content.

That's because your Internet explorer object was not created from the Microsoft Internet controls library. You need to make that change and the error will go away. Your document variable and your application variable are coming from two different places that's why. Thus they are not compatible with each other

Thank you for the reply and for the help. How do I create my Internet Explorer object from the Microsoft Internet Controls Library?

You have to reference that library in the visual basic editor, which I'm sure you know how to get to in excel. I believe that library, as it should, comes by default when you install office of any version because it's been around for quite some time.I think last time I remember seeing it in folder, the address for where library should be is this

C:\windows\system 32\shdocview.dll