• 0

(HELP) VBA Macro for Web form


Question

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! :)

Link to comment
https://www.neowin.net/forum/topic/1167673-help-vba-macro-for-web-form/
Share on other sites

6 answers to this question

Recommended Posts

  • 0

This is going to be quite complex and you already said you are brand new to this

 

This page describes the process have a look at it

 

http://www.ozgrid.com/forum/showthread.php?t=170186

  • 0

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!

  • 0
  On 06/08/2013 at 18:41, The World Is Yours said:

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

  • 0
  On 06/08/2013 at 19:12, Kalint said:

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!

This topic is now closed to further replies.
  • Posts

    • TP-Link Tri-Band AXE5400 Wi-Fi 6E Gaming Router Archer GXE75 is just $135 by Sayan Sen If you’re juggling gaming consoles, 4K streams and a growing roster of smart devices, the TP-Link Archer GXE75 Tri-Band AXE5400 Wi-Fi 6E Gaming Router is a good option to look at right now, considering the device is currently on sale at just $135 (purchase link under the specs table below). The Archer GXE75 promises up to 5.4 Gbps of throughput across three bands: 574 Mbps on 2.4 GHz, 2402 Mbps on 5 GHz and 2402 Mbps on 6 GHz (HE160 channels enabled). A 2.5 Gbps WAN/LAN port pairs with three 1 Gbps LAN ports and a USB 3.0 port for fast file sharing or printer access (purchase link down below). The quad-core CPU and 512 MB of RAM should help to handle multiple streams without bogging down, while MU-MIMO, OFDMA and 1024-QAM improve efficiency when several devices connect simultaneously. The router’s built-in Game Accelerator engine is said to automatically prioritize gaming packets (both wired and wireless), and TP-Link’s GPN (Gamers Private Network) acceleration can reduce packet loss for supported titles. HomeShield security brings firewall protection, device quarantining and parental controls. The technical specifications of the router are given below: Specification Details Wireless Standards IEEE 802.11ax 6 GHz; IEEE 802.11ax/ac/n/a 5 GHz; IEEE 802.11ax/n/g/b 2.4 GHz Wi-Fi Speeds 6 GHz: 2402 Mbps (802.11ax); 5 GHz: 2402 Mbps (802.11ax); 2.4 GHz: 574 Mbps (802.11ax) Spatial Streams 6 streams (tri-band OFDMA/MU-MIMO) Processor 1.7 GHz 64-bit Quad-Core CPU Memory 512 MB high-speed RAM Ethernet Ports 1× 2.5 Gbps WAN/LAN; 1× 1 Gbps WAN/LAN; 3× 1 Gbps LAN USB 1× USB 3.0 SuperSpeed port (up to 10× faster than USB 2.0) Antennas 4× high-performance external antennas with Beamforming Buttons Power On/Off; Reset; WPS/Wi-Fi; LED On/Off Working Modes Router Mode; Access Point Mode Security WPA, WPA2, WPA3, WPA/WPA2-Enterprise; SPI firewall; Access Control; IP/MAC binding; Application-layer gateway; HomeShield security suite VPN OpenVPN, PPTP, L2TP (server & client); WireGuard (server & client) Software & Services IPv4/IPv6; TP-Link HomeShield; EasyMesh; Parental controls; QoS by device; WAN types (Dynamic IP, Static IP, PPPoE, PPTP, L2TP); DDNS (TP-Link, NO-IP, DynDNS); auto firmware updates Gaming Features Game QoS boost; gaming-port priority; Gamers Private Network acceleration; game-port forwarding; real-time game panel with stats & RGB control Operating Environment 0 °C – 40 °C; 10 %– 90 % non-condensing humidity Get the TP-Link Tri-Band AXE5400 Wi-Fi 6E Gaming Router Archer GXE75 at the link below: TP-Link Tri-Band AXE5400 Wi-Fi 6E Gaming Router Archer GXE75 | EasyMesh, HomeShield: $159.99 + $25 off with coupon => $134.99 (Sold and Shipped by Amazon US This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • Oh no... here we go again. Tha same sh*t that happaned to Mail & Calendar...
    • I too have worked with pro gear for decades and so I found the interface to be unintuitive from both the pro and casual side (a rare "accomplishment" by what are obviously otherwise skilled coders, hehe). I eventually got it to work, thanks for offering, but I found other compatibility issues with my own use case, so I just dropped it entirely. Right now, I just use an analog line out/line in approach which works as expected across all usage scenarios. With both machines on the same power block/outlet, I'm not getting any analog hum or hiss. My next step will be to try the updated Multiplicity 4 when a bug, addressing this very issue unfortunately, is resolved. Knowing Stardock, that could be tomorrow or five years from now, so I check back every few months to see it it's fixed and I want to upgrade. Again, thanks for offering to help.
    • We recognize that performance can use some improvements, and we continue to work on improving it. However, it's worth noting that massive performance improvements don't happen overnight, they take a lot of work and effort, and in most cases, the improvements are more noticeable when you compare across several updates. That said, Files is open-source and everyone is invited to help with these efforts 🙂
  • Recent Achievements

    • Rookie
      Snake Doc went up a rank
      Rookie
    • First Post
      nobody9 earned a badge
      First Post
    • One Month Later
      Ricky Chan earned a badge
      One Month Later
    • First Post
      leoniDAM earned a badge
      First Post
    • Reacting Well
      Ian_ earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      495
    2. 2
      Michael Scrip
      203
    3. 3
      ATLien_0
      197
    4. 4
      Xenon
      137
    5. 5
      +FloatingFatMan
      115
  • Tell a friend

    Love Neowin? Tell a friend!