file exist

  • Thread starter Thread starter Lior Montia
  • Start date Start date
Lior said:
hi,

what is the command to check if file exist ?

thanks.
Click to expand...

Dir("path to file")

It will return the name of the file if it exists and "" if it does not.
 
Lior Montia said:
hi,

what is the command to check if file exist ?

thanks.
Click to expand...

Dir() will see if a file of folder exists, but only if you have access to it
(permissions, connectivity). I'm not sure you can see if something exists
without those permissions.
 
You must log in or register to reply here.

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

Similar Threads

Folder Exists 2
Excel VBA 0
File of a photo exist 1
Check if objects exist 2
Checking if a valid file exists 13
Excell 2021 0
Overwriting files 9
Check if an external file exists 3

Back
Top