webscrape from a IE pop up window

tomcatonnet99

Board Regular
Joined
Jan 30, 2011
Messages
73
I've managed to get to the active window ( the pop up window) but am unable to access information in what appears to be a table within ( the table doesn't have a name and only thing to go by is classnames...

attached is the html / jsp code

would appreciate some help here pls...
HTML:
<

body ******="init()">
<
div class="centerAlign">
    
<table class="checkpointInfoTable">
        
<tr>
            
<td><img src="/npts/images/blank.gif" width="14"/></td>
            
<td>
                
                
<table border="0" cellspacing="0" cellpadding="3">
                    
<tr>
                        
<td class="whiteTdCenter" align="center"> </td>
                    
</tr>
                    
<tr>
                        
<td class="whiteTdCenter" align="center">Airwaybill: 1603574696
                        
</td>
                    
</tr>
                
</table>
                
<table border="0" cellspacing="0" cellpadding="3">
                    
<tr>
                        
<td class="whiteTdCenter" align="center">Checkpoint: Courier Post Checkpoint
                        
</td>
                    
</tr>
                
</table>
                
<table border="0" cellspacing="0" cellpadding="3">
                    
<tr>
                        
<td class="whiteTdCenter" align="center">Station: XXF
                        
</td>
                        
<td class="whiteTdCenter" align="center"> </td>
                    
</tr>
                
</table>
                
 
 
                
<table border="0">
                    
<tr>
 
                            
<table border="0" cellspacing="1" cellpadding="2">
                                
<tr>
                                    
<td> </td>
                                
</tr>
                                
<tr>
                                    
<td> </td>
                                    
<td class="blackHeading borderCheckPoint" align="left">NAME</td>
                                    
<td class="blackHeading borderCheckPoint" align="left">VALUE
                                    
</td>
                                
</tr>
                                
                                
<tr>
                                    
<td> </td>
                                    
<td class="whiteTdNormal borderCheckPoint">Remarks
                                    
</td>
                                    
<td class="whiteTdNormal borderCheckPoint"> CPT026  --------------------------------------------------------this is what I'm after                                    
                                    
</td>
                                
</tr>
                                
                                
<tr>
                                    
<td> </td>
                                    
<td class="grayTdNormal borderCheckPoint">subcode
                                    
</td>
                                    
<td class="grayTdNormal borderCheckPoint">CP
                                    
</td>
                                
</tr>
                                
                            
</table>
                        
</td>
                    
</tr>
                
</table>
            
</td>
        
</tr>
    
</table>
</
div>
</
body>
</
html>
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Hello tomcatonnet99,

Unlike the ID attribute which is unique for each element, the Class attribute is not since it is most often used for formatting elements. First, you will need to return a collection of all the Tables on the web page. Step through the collection starting at 0 to Length - 1. Check the ClassName attribute of each Table for a match. If you have more than 1 table with this class name, you will need to examine the HTML to find the index number that points to your table. Once you know the Table's index number you can access the element directly.
 
Upvote 0

Forum statistics

Threads
1,224,817
Messages
6,181,148
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top