Import Web Data to Excel using VBA Macros


I see your tutorial Thanks a lot, but i am little amateur with html code.. its work fine for this type of web page yahho e.t.c .. but if i have a part of web page and i need got some number from site

 <div class="rate d-flex align-items-center justify-content-center">3,57</div>

if ive use your formulla ive got only error message  

test = html.getElementsByClassName("rate d-flex align-items-center justify-content-center").Item(0).innerText

its only came as object .. what i need to do .. Can you help me with that ? 



You're welcome :)

These class names are very generic. I'd say that you need to go out to a tag that encloses that and has a unique identifier for the class or id. This is a common problem and always required fiddling around. You may end up bringing additional data into Excel and then needing to clean it there.
don (rep: 1959) Jan 23, '21 at 1:41 pm
But i am affraid i didnt find anything out because these part is only visible in ispection of web page .. if i show url code there is some part called  <div id="reactAppRoot">   </div>       <script type="text/javascript"

and probably with that it will be problem or not ?? Or i need to go out to a tag that encloses that and has a unique identifier for the class or id. and it must be worked anyway ?? thanks for help don.  
Cassius Jan 23, '21 at 2:57 pm
We can give you very good advice for hours and days on end and still not solve your problem. Consider posting your code or, even better, a workbook with the code in it. Bear in mind that this is a Q & A forum. Don't hide vital details of your question in the "Discussion". Edit your qstion so that it says what you want us to know.
Variatus (rep: 4382) Jan 24, '21 at 6:39 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login