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

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.

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

Please ignore, I figured it out...

"mc" wrote:

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.

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

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

"mc" wrote in message
...
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.

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

Yes, you are correct, I figured that out a few minutes later. Thanks for the
response!

"Peter T" wrote:

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

"mc" wrote in message
...
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.