I got many cells from A1 to A500... every of it containing a path to a
txt file (D:\Test\test1.txt ... and so on). Does somebody know how to
refere in my macro at these cells, so I can open the files they are
refering at ?
I want to do this in order to verify if they have a keyword inside, so
I want to open them and see if there is that word present.

Basically I thought to make a for statement which refers to A1:A500
range, and inside it to Open the files from these cells, verify if the
first word is "Complete", and if not, to copy the whole path for the
file in another Workbook or Sheet.

The problem is I don't know if it's possible, and how to write it in VB
code.
Any idea or help is high appreciated.
Thanks.


--
mariustony
------------------------------------------------------------------------
mariustony's Profile: http://www.excelforum.com/member.php...o&userid=25913
View this thread: http://www.excelforum.com/showthread...hreadid=472889