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.

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.
>

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" <(E-Mail Removed)> wrote in message
news:AEC3811F-7D78-41EC-AB8F-(E-Mail Removed)...
>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.
>

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" <(E-Mail Removed)> wrote in message
> news:AEC3811F-7D78-41EC-AB8F-(E-Mail Removed)...
> >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.
> >
>
>
>