Sign in to follow this  
Followers 0
The World Is Yours

(HELP) VBA Macro for Web form

7 posts in this topic

Hello Neowin Forum,

I don't really understand much about the subject (in fact, I am brand new at this).
I am willing to create a project in my company about IE automation.

Every single day, we have to fill the same form, over and over again. This form is located on a website developed for the company, a customized system. It seems to be in Java (don't know very well).

I would like to create a VBA Macro in order to fill it automatically.

- Is it possible?
- Is there any kind of protection/security (by the fact of being a customized system) that might make it impossible?

So far I have this code:


Sub UseInternetExplorer()
Dim ieApp As New SHDocVw.InternetExplorer
ieApp.Visible = True
ieApp.Navigate "http://epmo.intranet.com.aspx"
Do While ieApp.Busy
Loop



End Sub




How do I find the hyperlink and perform a click on it?
What about dropboxes and textfields?


Thanks for the attention and patience! :)

Share this post


Link to post
Share on other sites

Hello Haggis, thanks for the reply!

 

 

I am being able to fill some of the textboxes with the code below:

 

Sub AcessaPagina()

Dim ie As InternetExplorer
Set ie = New InternetExplorer

ie.Navigate "http://epmo.intranet.com/Webforms/TaskCreation.aspx"

While ie.Busy
Wend

ie.Document.getElementById("Content_TEXT_ALPHA_COLUMN1").Value = "DAI COMPANY"
ie.Document.getElementById("Content_TEXT_ALPHA_COLUMN2").Value = "FEUMITO"
ie.Document.getElementById("Content_TEXT_ALPHA_COLUMN14").Value = "5B3"

ie.Visible = True

End Sub

However, sometimes I receive the message object doesn't support this property or method .
Do you happen to know why?

One last thing: in this same page, I have to select some Dropdown lists.  How can I do that?

 

Thanks a lot!

Share this post


Link to post
Share on other sites

Hello Haggis, thanks for the reply!

 

 

I am being able to fill some of the textboxes with the code below:

 

Sub AcessaPagina()

Dim ie As InternetExplorer

Set ie = New InternetExplorer

ie.Navigate "http://epmo.intranet.com/Webforms/TaskCreation.aspx"

While ie.Busy

Wend

ie.Document.getElementById("Content_TEXT_ALPHA_COLUMN1").Value = "DAI COMPANY"

ie.Document.getElementById("Content_TEXT_ALPHA_COLUMN2").Value = "FEUMITO"

ie.Document.getElementById("Content_TEXT_ALPHA_COLUMN14").Value = "5B3"

ie.Visible = True

End Sub

However, sometimes I receive the message object doesn't support this property or method .

Do you happen to know why?

One last thing: in this same page, I have to select some Dropdown lists.  How can I do that?

 

Thanks a lot!

Why dont you explain exactly what you're doing because I dont know what the hell is going on.  Yes you can do a dropdown list

 

This looks pretty good on automation:http://www.excely.com/excel-vba/ie-automation.shtml#.UgFMVtK1GUY

Share this post


Link to post
Share on other sites

If you can use Firefox there's extensions avalaible to auto fill form.

Share this post


Link to post
Share on other sites

If you can use Firefox there's extensions avalaible to auto fill form.

I can't  :(

It has to be on IE... 

Share this post


Link to post
Share on other sites

Why dont you explain exactly what you're doing because I dont know what the hell is going on.  Yes you can do a dropdown list

 

This looks pretty good on automation:http://www.excely.com/excel-vba/ie-automation.shtml#.UgFMVtK1GUY

I am trying to create this code to auto fill a form in website (intranet).

So far, I am being able to fill the textboxes, but sometimes I receive the message error : object doesn't support this property or method

 

Do you know why I keep receiving this message?

 

Also, there are some drop down lists that I have to select in the same page.

How can I do that?

Thanks!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.