M
Maxi
Tim helped me with a code to open browser through vba and navigate a
website. Code given below. However, I have two questions.
Sub foo()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate Range("A1").Value
Do While IE.ReadyState <> 4
DoEvents
Loop
With IE.document.all
.Uname.Value = "myUsername"
.Pass.Value = "myPassword"
.Submit.Click
End With
Do While IE.ReadyState <> 4
DoEvents
Loop
End Sub
Question1: If the webpage has a table and I want to look up data from
those tables then how do I find that out?
For instance: In the webpage I have lots of tables and in one of the
table which is of size 4X2 (4 rows and 2 columns). On the left side
there will be headings and on the right side a dynamic value.
Example
Report Owner: Maxi
Sent by: Tom
Sent to: Dick
Verified by: Harry
Somewhere down the code, I need a code that will check the Report
Owner, Sent by, Sent to, and Verified by and update it in cells B1 C1
D1 and E1. I have all my links in column A1:A25. I don't want to use a
web query because I have 25 links to loop through (mywebsite.com/
page1.htm, mywebsite.com/page2.htm .... page25.htm)
Here is the html code of the table
<table class="myPanel" border="0" cellpadding="2" cellspacing="0"
width="100%">
<tr class="row1">
<td class="rowLabel">Report Owner:</td>
<td valign="top">Maxi</td>
</tr>
<tr class="row0">
<td class="rowLabel">Sent by:</td>
<td><b>Tom</b></td>
</tr>
<tr class="row1">
<td class="rowLabel">Sent to:</td>
<td>Dick</td>
</tr>
<tr class="row0">
<td class="rowLabel">Verfied by:</td>
<td>Harry </td>
</tr>
</table>
I have read articles which says you can get it by getElementByID but
for that I need <table id="some name" but in my html code, there is no
"id", it says <table class="myPanel". Here I am getting confused.
Question1:
There will be an hyperlink on all pages that says "take me here" how
can I click on that website programatically?
Need help
Thank you
Maxi
website. Code given below. However, I have two questions.
Sub foo()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate Range("A1").Value
Do While IE.ReadyState <> 4
DoEvents
Loop
With IE.document.all
.Uname.Value = "myUsername"
.Pass.Value = "myPassword"
.Submit.Click
End With
Do While IE.ReadyState <> 4
DoEvents
Loop
End Sub
Question1: If the webpage has a table and I want to look up data from
those tables then how do I find that out?
For instance: In the webpage I have lots of tables and in one of the
table which is of size 4X2 (4 rows and 2 columns). On the left side
there will be headings and on the right side a dynamic value.
Example
Report Owner: Maxi
Sent by: Tom
Sent to: Dick
Verified by: Harry
Somewhere down the code, I need a code that will check the Report
Owner, Sent by, Sent to, and Verified by and update it in cells B1 C1
D1 and E1. I have all my links in column A1:A25. I don't want to use a
web query because I have 25 links to loop through (mywebsite.com/
page1.htm, mywebsite.com/page2.htm .... page25.htm)
Here is the html code of the table
<table class="myPanel" border="0" cellpadding="2" cellspacing="0"
width="100%">
<tr class="row1">
<td class="rowLabel">Report Owner:</td>
<td valign="top">Maxi</td>
</tr>
<tr class="row0">
<td class="rowLabel">Sent by:</td>
<td><b>Tom</b></td>
</tr>
<tr class="row1">
<td class="rowLabel">Sent to:</td>
<td>Dick</td>
</tr>
<tr class="row0">
<td class="rowLabel">Verfied by:</td>
<td>Harry </td>
</tr>
</table>
I have read articles which says you can get it by getElementByID but
for that I need <table id="some name" but in my html code, there is no
"id", it says <table class="myPanel". Here I am getting confused.
Question1:
There will be an hyperlink on all pages that says "take me here" how
can I click on that website programatically?
Need help
Thank you
Maxi