creat a macro to look for a file

  • Thread starter Thread starter Kelly******
  • Start date Start date
K

Kelly******

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top