the easiest way is to make a copy of the worksheet and save as text.

'copy active sheet to new workbook
'copy without before or after creates new workbook
ActiveSheet.Copy
Set Newbk = ActiveWorkbook
Newbk.SaveAs _
Filename:="C:\TEMP\Book2.txt", _
FileFormat:=xlTextMSDOS
Newbk.Close savechanges:=False

"fi.or.jp.de" wrote:

Joel, thank you

is there any option in coding when ever the table is been copied,
as usual it paste in excel. I want another copy in Text.txt format. ?

On Oct 8, 10:30 pm, Joel wrote:
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.