Is there a way to extract the cell call data of a particular field from a website?
-
I have a list of 1000 urls and from each url I need to get a particular text field into the excel sheet. Is it possible?
-
Answer:
Write a VBA function that takes two arguments. One for the url and one for the text field. This can be done by slightly modifying the code given here: http://www.vbaexpress.com/forum/showthread.php?31831-How-to-parse-HTML-file-from-VBA-code-into-Excel Just change the sub routine to a function and add the two arguments. Then you can call the function from any Excel cell giving it one of the 1000 urls and text fields as input.
Rógvi Dávid Arge at Quora Visit the source
Other answers
Agreed with Nika. that's the best option. If not you can grab stuff from a web page using VBA and targeting HTML id's
Steve Quatrani
You can import information from web by using From Web, in the Data Tab and then organize data the way you want. Maybe you can give a live example to answer better this question.
Nika Akahalaia
Related Q & A:
- How to delete a particular line from a file?Best solution by Stack Overflow
- Is there a way of putting the Python Shell output in a tkinter window?Best solution by Stack Overflow
- Is there a way to check my cell's voicemail from another phone?Best solution by wikihow.com
- How to search for a particular string in a text file using java?Best solution by Stack Overflow
- Is there a way to send pictures from my computer to a cell phone?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.