ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Joel, Need your help (https://www.excelbanter.com/excel-programming/435004-joel-need-your-help.html)

fi.or.jp.de

Joel, Need your help
 
Hi Joel,

I am using Excel vba for web automation.
You have given valuable information in my last post.
But I am not able to get that.

I have web, a table.
In a table there are some link which shows as 'multiple'

If i put web cursor it will show value.

I need copy those value into excel using vba.

'''HTML SOURCE CODE"""""""

<a href="javascript:onMultipleBIANumLinkClick('XXXX_, _XX8')"
title="ABCD1234" id="bia_row_bia_num_155" name="a_iaa_tdBIANum"
Multiple (2)</a


''''''''''''''''''''''''
Joel, I need what ever the value exist for title ie., ABCD1234.

joel

Joel, Need your help
 
I don't know if you will receive thsi message. the microsoft web user group
isn't sending out emails.

set biaNum = IE.document.getElementById("bia_row_bia_num_155")
there will be a title property either for this object or the parent object

msgbox(bianum.title)
or
msgbox(parentnode.bianum.title)


"fi.or.jp.de" wrote:

Hi Joel,

I am using Excel vba for web automation.
You have given valuable information in my last post.
But I am not able to get that.

I have web, a table.
In a table there are some link which shows as 'multiple'

If i put web cursor it will show value.

I need copy those value into excel using vba.

'''HTML SOURCE CODE"""""""

<a href="javascript:onMultipleBIANumLinkClick('XXXX_, _XX8')"
title="ABCD1234" id="bia_row_bia_num_155" name="a_iaa_tdBIANum"
Multiple (2)</a


''''''''''''''''''''''''
Joel, I need what ever the value exist for title ie., ABCD1234.
.



All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com