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

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

Peter T

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
 

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

Check existence of a file if the file name has spaces in it 1
OneDrive substituting "+" sign in place of space 0
Name of file opened, being viewed 2
Working outlook via vba code with xlsx - error 0
Word OLE to check spelling in text box 1
Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
Merging from an Excel file with graphics 1

Top