I have a list of urls of websites and i need to get linkedin and Twitter Id from each of the websites. How can I use macro or functions to take only required data to sheet. Each website using different sintax for the links. May be needed to serch and find with keyword, Please help.
Your post is pretty vague. I think you are asking how to scrape some info from a website. You'll probably need to use Selenium to scrape websites. All websites are constructed differently so I think you'll need to use XPath to extract elements. There is a Selenium .COM addin called SeleniumBasic. Need more details on websites.
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks