Hi guys i just started learning how to automate web applications by using EXCEL MACROS.It's very interesting topic. So far i learnt how to open internet explorer , how to open a particular website , how to pass data into particular text field , how to click a particular Button or tab and how to click and select value from drop down box.Now i'm trying to open combobox very soon i'll get.
function Automation()
Dim IE As Object
Set IE = CreateObject("Internetexplorer.Application")
IE.Navigate "https://facebook.com"
IE.Visible = True
While IE.busy
DoEvents 'wait until IE is done loading page.
Wend
end function
How to open Facebook in Internet explorer :
Just do it in excel macros and run it then you'll experience the real automationfunction Automation()
Dim IE As Object
Set IE = CreateObject("Internetexplorer.Application")
IE.Navigate "https://facebook.com"
IE.Visible = True
While IE.busy
DoEvents 'wait until IE is done loading page.
Wend
end function
No comments:
Post a Comment