Check existence of a file if the file name has spaces 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.
 

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 file if file name has a space in it. 3
Justification function versus wide spaces 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