Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check File Name Existence in Array | Excel Programming | |||
Check for existence of a file | Excel Programming | |||
Check File Existence | Excel Programming | |||
Test for file existence | Excel Programming | |||
Vba - Checking existence of file | Excel Programming |