creat a macro to look for a file
 

How would you creat a link or macro to look for a file if
it doesnt find the file is doesnt do anything if it does
it opens it

I can think of one solution

public sub fileopening()
on error resume next
workbooks.open (".................")
end sub


Kelly****** wrote in message
...
How would you creat a link or macro to look for a file if
it doesnt find the file is doesnt do anything if it does
it opens it