PDA

View Full Version : VBA to open Web page and Enter Data in Text Box on webpage and click on Submit



Sweek
05-13-2011, 02:34 AM
Hi,

I am trying to open a webpage and enter the data from Excel sheet to Webpage Textbox. The web page is.html and is designe in Flex.

Is this possible to do this job?...

I have found this to open the webpage on button click but how to proceed ahead?



Set browser = CreateObject("InternetExplorer.Application")
browser.Navigate ("WebAddress")
browser.StatusBar = False
browser.Toolbar = False
browser.Visible = True
browser.Resizable = False
browser.AddressBar = False






Regards,
Sweek

stanleydgrom
05-13-2011, 05:37 AM
Sweek,

Welcome to the VBA Express forum.

Look at:
Automation of an system issue.
http://www.vbaexpress.com/forum/showthread.php?t=35623

Check out AutoIt
http://autoitscript.com/autoit3

AutoIt v3 is a freeware BASIC-like scripting language designed for automating the Windows GUI and general scripting. It uses a combination of simulated keystrokes, mouse movement and window/control manipulation in order to automate tasks in a way not possible or reliable with other languages (e.g. VBScript and SendKeys). AutoIt is also very small, self-contained and will run on all versions of Windows out-of-the-box with no annoying “runtimes” required!

AutoIt was initially designed for PC “roll out” situations to reliably automate and configure thousands of PCs. Over time it has become a powerful language that supports complex expressions, user functions, loops and everything else that veteran scripters would expect.


Have a great day, and weekend,
Stan