Check existence of file if file name has a space in it.

  • Thread starter Thread starter mc
  • Start date Start date
M

mc

I know how to check the existence of a file but what if the file name has a
space in it? For example, "Futures Curves.xls" When I use the
Len(dir(FileName), it is returning 0 for the len.
 
I suspect there's something wrong with 'FileName', the path perhaps; a space
in the file name would not prevent Dir from returning a value.

Regards,
Peter T
 
Yes, you are correct, I figured that out a few minutes later. Thanks for the
response!
 
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

Move all except latest to another folder 2
Directory Name - IF Named Range Exists 0
unable to create a file if already exiists 2
comparison of 2 approaches for identifying file existence 6
Open File Macro 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Split ActiveCell.Value and delete element if......... 6
find file exists 1

Back
Top