Search results for query: *

Hello, I have a problem with my code. It currently works fine, by searching through a directory, finding every .html & .htm, searching through that file for any href's, and then printing them into a spreadsheet. The problem I have seemed to encounter though, is that some files have the .html...

Yea, the main concern isn't with actually getting the info, because they will be able to view it anyway. They just don't want it to be easily gotten and dispersed. They want the user to HAVE to go to the website to get the info every time.

Because they are private documents only that are in regards to governement regulated business.

Hello I have a quick question regarding a data reader for SharePoint. My client has documents in their document library, that they want their customers and others to be able to VIEW on the site only. They want it so that the files CANNOT be downloaded or sent electronically. Kind of...

huh, yea for some reason that code keeps giving me compile errors...

Hello, I have a Sub here for deleting any entire row, where "http" is NOT found throughout column B. There are about 45,000 rows of data that its searching and its taking a very long time. Is there a way I can change the current code to speed up the process, the code is below. Thanks! Mark...

Hello Just hoping someone can send me in the right direction here with a method that might work here. I am extracting data from text files based on finding a certain word. If found, the whole line in the text doc will be pasted into a row in excel. There are certain things in these rows...

awesome! great thanks soo much, I've been messing with this code for the past day, great to finally get it done. Thanks again! Mark

Thanks a lot Skip, It seems to be actually computing now which is a relief. The only thing is when it computing it looks like it keeps replacing the next file with the one already printed, essentially ending the computing with only one line...Any ideas? I'm trying to fool around with it now.

Hello I have a filesearch.application running in my code that works fine. I need to somehow within that code, open each file that it finds, search it for a reference, and then if found print the enite line into excel. I have the following code that give me errors on the open part. myPath...

Hello PVS One question. So I am using the fielsearch.application and it works fine, it finds all the .html files throughout all the subfolders and prints the amount found in a messagebox. What I want tho, is after each .html file is found, for it to be searched for any 'href' instance, and...

Hello I have a parent folder called MySite. There are child folders within it. I want to search through VBA the parent folder and all subfolders for any .htm file. Then each .htm file is searched for any reference of an 'href' tag. For some reason I can only get it to pull the one file from...

Thanks so much Swi, it ended up being adding the vbTextCompare!! Works like a charm now!

when I do that its saying that the value of: If InStr(1, WholeLine, "href") > 0 Then - is '0' so thats probably why nothing is happening. But...the file DOES contain that, I brought it up in a notepad and did a search.

I am trying to loop through multiple text files within a specified folder. Essentially I am searching for any 3rd party websites so I have a search for href tags. I think want the url for these to be exported into Excel. I have the following code but it does nothing... Sub...