LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Make excel check external file paths

I have a spreadsheet which contains thousands of file paths going doing
column A. I wanted excel to be able to look at cell A1, A2 and so on
and check if the file does exist on the harddrive and then return in
cell B1 return Yes or No.

I wanted this to loop until it reaches the end of the file paths and
has returned yes or no for all of them.

Thanks in advance.

Stuart

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel file paths Jane Excel Discussion (Misc queries) 1 August 17th 06 04:59 PM
How to check if external .txt file has text in it... LL Cool A Excel Programming 2 May 7th 06 07:45 PM
file paths hr Excel Discussion (Misc queries) 0 December 7th 05 04:59 PM
Printing Excel Formulas without file paths updating Kim Excel Discussion (Misc queries) 0 August 18th 05 04:55 PM
Relative paths to external data? Christopher Blue Excel Discussion (Misc queries) 3 January 1st 05 08:14 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"