I have multiple urls. I want to use excel for checking a specific text in source code of every URLs (websites).
Please help me by giving me a sample excel document.
The idea is , I will put all URLS in a column. Then excel will go through the source code of every URL. In next column it will say after running the program about status of text which I am trying to find in source code.
I am totally new to excel.
Thanks
Prashant
Please have a look at the attachment. The macro will download the text of the site and search for the specified term. If gives true if it finds it.
The code can be seen in Module1 in the VBA editor (Alt F11)
Martin
Hi mrice,
Apologies for my green-ness but I have exactly the same problem as the OP. However, I get an error when I run the example - a problem with "Open "C:/temp/myfile" For Input As #1"
Could it be the version of Excel causing the issue (I'm on 2010)? Can the source code be written elsewhere?
Any help would be greatly appreciated!
Thanks,
Daniel
Is the file C:/temp/myfile being created - can you find it on your C drive?
Seems to be a problem getting the Google data and, consequently, creating/finding the temp file.
Maybe a bit of overkill on the error handling but ...
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi mrice/TMS,
Thanks for your speedy replies and help.
@mrice - No I can't find that file so I guess its not being created?
@TMS - I'm getting a runtime error when I run your solution (same as the original solution) and it points out "Open sFile For Input As #1" as the issue when I debug. However, it has some life in it as it returns "FALSE" next to the hyperlink to this site (which has 7 or so mentions of "macro")!
Daniel
Hi all.
I have been scouring the internet for a solution that does just this and have the same error. Can you help?
I tried to create a dir and file "myfile" to help but too no avail.
Since the thread is old, maybe there are more modern solutions to this?
Many thanks in advance for the help.
@pizzaiollo: Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks