Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Import Web Data to Excel using VBA Macros

0

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 ? 

excel
MS Office Version: Office 365
posted by: Cassius on Sat Jan 23, 2021 at 8:19 am
Answer
Discuss

Discussion

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: 1989) 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: 4889) 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