Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear Gentlemen
I need help for code to download for each strServAcct 2 items from web page into cells in workbook. This 2 items are "Cash Balance" and "Total Cash Used" This is how worksheet should look like: Col A Col B Col C strServAcct Cash Balance Total Cash Used 1190535741 xx.xx USd xx.xx USD 1615242148 xx.xx USd xx.xx USD 3484690293 xx.xx USd xx.xx USD 6689883508 xx.xx USd xx.xx USD This is what I have so far: Private Sub Workbook_Open() Net2Phone1 End Sub Sub Net2Phone1() 'Credit to Joel Dim objIE As Object Dim strServAcct As String Dim Password As Object strServAcct = "1190535741" Set objIE = CreateObject("InternetExplorer.Application") objIE.Visible = True objIE.Navigate "https://partner.net2phone.com/apps/account/search.aspx" WaitForLoad objIE Set UserId = objIE.document.getElementById("txtUserID") If Not UserId Is Nothing Then 'Input user name and password UserId.Value = "famaperu45" Set Password = objIE.document.getElementById("txtPassword") If Not Password Is Nothing Then Password.Value = "my69car" 'submit the form by clicking "Login" Set Login = objIE.document.getElementById("btnlogin") Login.Click WaitForLoad objIE End If End If Set AccountBox = _ objIE.document.getElementById("ctl00$pageBody$txtS erviceAccount") AccountBox.Value = strServAcct Set SearchButton = _ objIE.document.getElementById("ctl00$pageBody$btnS earch") SearchButton.Click WaitForLoad objIE objIE.Navigate "https://partner.net2phone.com/apps/account/calls.aspx" WaitForLoad objIE ' in this web page are the "Cash Balance" and the "Total Cash Used" End Sub Sub WaitForLoad(IE As Object) Do While IE.Busy = True Or IE.readystate < 4 DoEvents Loop End Sub Your help will be greatly appreciated. Thanks & regards farid2001 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
items chosen to download are NEVER all there after download comple | New Users to Excel | |||
SAP download Web page to XLS | Excel Programming | |||
practice sessions won't download get error on page | New Users to Excel | |||
when I try to download excel template, it says Error on page | Excel Discussion (Misc queries) |