| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refere to cell representing a path to a file
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting the file path in a cell | Excel Discussion (Misc queries) | |||
| double click on cell that have link, Excel will jump to the refere | Excel Worksheet Functions | |||
| Using UNC path instead of URL to link cell to PDF file | Excel Worksheet Functions | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Named cells in a worksheetchange macro instead of hard cell refere | Excel Programming | |||
Threaded Mode
