Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Web scrapping a link
Jerry Fowler 
       
2 years ago
I have been using the process you taught in one of your TechHelp videos to scrape items off of web pages. I have been able to figure out most of what I want (with help from you and your team) but the latest item is I'm trying to grab a link off of your webpage (like "https://599cd.com/blog/display-article.asp?ID=3170") and them grap the links off the comments section for the transcript and the quiz (see image). As of yet, I have not been able to. Any suggestion or direction would be greatly appreciated.
Jerry Fowler OP  @Reply  
       
2 years ago

Adam Schwanz  @Reply  
           
2 years ago
So what are you trying to do, just get the numbers on the end? You can use like mid and instr combination to find the text CommentID= then just remove the commentID from the string leaving only the numbers.

That would be something like this
    Dim X
    X = Mid(MyTextField, InStr(MyTextField, "CommentID="))
    X = Replace(X, "CommentID=", "")
    MsgBox X
Alex Hedley  @Reply  
           
2 years ago
Ask Richard to add a custom id or class so it's easier for you to grab

Otherwise you'll just have to traverse the DOM as usual.
Jerry Fowler OP  @Reply  
       
2 years ago
Adam, right now I go to the page and hover my mouse over the link to see the commentID, then I have a function that uses that ID to grab either the Quiz or the Transcript and save it for retrieval. I would like to automate that process as much as possible. Alex thanks for the suggestion.
Rick, would that be possible? or if I configure how to grab them without having that I'd be happy to do that as well.
Richard Rost  @Reply  
          
2 years ago
It should be easy enough to read the comment IDs like Adam said, but I'm not going to set anything up specifically for this because what you're seeing now is only temporary. I plan on adding actual fields in my database for the transcript instead of just making it a comment; it'll be part of the master page, and the quiz is going into a whole separate quiz engine. So right now, they're just dropped into comments for simplicity's sake. Also, if you're screening my website, be careful because if you scrape it too much, I do have logic in my code that will ban your IP address. I think the limit is set to 40 hits per minute to thwart spammers and bots. I think Adam ran into that limit once. Lol.
Jerry Fowler OP  @Reply  
       
2 years ago
Rick, thanks for the info. What I'm doing now is not hard or time-consuming. And, I'm doing it on demand so I'm only scrapping twice when I do and then not every day.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/16/2026 7:51:01 PM. PLT: 1s