Thread: Web
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Web

the length property

NumRows = doc_tables(1).rows.length

"fi.or.jp.de" wrote:

Hey Joel,

I was using break mode & checking each code. for that reason
it was not enabled i guess.

Now just now tested without putting any break, view button enabled.

Thanks joel.

Joel, How do i check how many rows are available in a table ?



On Oct 8, 9:07 pm, Joel wrote:
You may not need enable the view button. I think you want the link location
which is probably in the href property. You can then take the URL from the
href property to get the object. You may want to open a 2nd IE explorer and
put the URL obtained from the href into the 2nd IE so you still can go back
to the original URL without having to naviage back to the 1st URL.

"fi.or.jp.de" wrote:
Hi All,


I have table in web page with check box for each row.


And there is one option called "view", it is been disabled.


When i manually click the check boxes "view" button enables but when i
do
it on Excel Vba its not enabled.


check box code ..


For Each itm In ie.Document.getElementsByName("html_ckb_list")
itm.Checked = True
Next itm


How Can i enable "view" button ?


And also i need to copy the table to excel sheet ?


How can i achieve this.


I need to login web page and need to go for some other tabs to grab
this info.
So, I didn't mentioned the web address.


I know without web address it is difficult but any small clues will
help me more. i will try
for the rest, just give me hints to enable button and copy table
contents.


Thanks in advance.