Fill Form with VBA. Problems with .busy .readyState

**Zheno** · 01-16-2012, 05:13 AM

I Have some code that goes through cells in my spreadsheet opens the hyperlink in the cells, Puts in logging information and prints the file.

Here is the code i use for this

Please Login or Register  to view this content.

The filepath is a variation of https://service.projectplace.com/pp/start.cgi? but if you put in that adress you can see the elements that you need.

This is the part of the code atm that i have problem with

Please Login or Register  to view this content.

i get an automatation error, undefined error.

When i first implented the code everything worked, but the second day when i was gonna try it out, it didnt work and it hasnt been working since then. I have tried diffrent methods of this oart of the code but i cant get it to work anymore.
Anyone that have any idea?

**Chippy** · 01-16-2012, 07:45 PM

See if you can incorporate this code into your code. It does the IE automation, populating and submitting the form, but obviously the login is rejected because I don't know a valid email address and password.

Please Login or Register  to view this content.

Also, there's really no need to use GoTo and the associated labels. Avoid them by reversing the logic of the If statement like this: If ActiveCell.Value <> "-" Then

**Zheno** · 01-17-2012, 02:45 AM

Thanks Chippy,

I still get the Automation error, undefined error on the code line

Please Login or Register  to view this content.

I have put reference to Microsoft HTML obejct and Microsoft Internet controls Is there some other reference i need to activate?

Just to be clear, i used your code in a new workbook so it shouldnt be anything else in my code messing it up.

Im really lost here why that line of code wont work for me.