Make Excel check for an external file

[Alexander Schek]

Hi,
In A1 I have a path to an image on my Hard Drive.. let's say
"c:\images\image1.jpg"
Is there any formula that would say YES or NO as a result if the image
(file) actually exist on the folder?
If so, how could I address this need ?
Thanks a lot!

Alex

 

[Bob Phillips]

Alex,

The Dir function will do this for you

myVar = Dir("C:\ges\image1.jpg")

it will return empty if it doesn't exist

 

[Alexander Schek]

Hi Bob,
Thanks for the reply.
I do not understand this ... I am pretty basic with formulas, so I do not
know how to make it.
Let me know if you can explain further.
Thanks a lot,
Alex