PDA

View Full Version : Import data from website



jnevada
06-05-2012, 09:19 PM
I need help to import data from a java script website to a worksheet via vba. The website is not HTML so there is no tags. The source code looks like this, the words in red is what I'm looking for:


<NOBR>6/4/2012NOBR><BR>DIV>
<DIV
ID="I1668"
CLASS=C570
***********="mouseOver('I1668', 'Deposits in Presentment Currency', '', '570', 'rp_FAS::frm_cnt_ncc_FAS::dbl_Deposits', '', '', '')"
STYLE="position:absolute;
left:63.00pt;
top:0.00pt;
height:16.00pt;
width:119.00pt;
line-height:10.94pt;
font-size:9.00pt;
text-align:right;
overflow:hidden;
padding-top:2.53pt;
">
<NOBR>0NOBR><BR>DIV>


Thanks very much in advance.

Jan Karel Pieterse
06-05-2012, 09:46 PM
Cross posted here:
http://www.mrexcel.com/forum/showthread.php?t=640059

jnevada
06-05-2012, 10:08 PM
Cross posted here:
http://www.mrexcel.com/forum/showthread.php?t=640059

Is it not allowed? Can you help me to delete it?

Thanks.

Aussiebear
06-06-2012, 02:47 AM
Sorry cannot delete your thread. Please visit this link to update your knowledge regarding cross posting.

http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters