Directory & File names with spaces - brackets usage

[JDB]

I am trying to open an Excel file thru Access VBA and cannot open the
file.
The various directories on the path have spaces in them i.e. "My
Documents".

I understand by various posts that I might need to use brackets around
the path, but cannot seem to find the right combinations of brackets
and double quotes to be able to open/read the file.

Any pointers would be helpful.

Thanks

JDB

 

[Paolo]

Hi JDB,
you must bracket the entire path e.g.

"c:\my documents\tmp\tmp.xls"

HTH Paolo

 

[Paolo]

Sorry,
I wrote bracket the entire path instead of enclose between quotation marks