Sorry, this is a re-post, the first did not show up after 8 hrs. will
try again.
--------------------------------------------------------------------------
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

On Tue, 8 Jul 2008 13:19:24 -0700 (PDT), JDB <(E-Mail Removed)> wrote:

>Sorry, this is a re-post, the first did not show up after 8 hrs. will
>try again.
>--------------------------------------------------------------------------
>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

Brackets won't help in this case; quotes will: e.g.

"C:\Documents and Settings\Username\My Documents\myspreadsheet.xls"

as a string value will point to the file.
--

John W. Vinson [MVP]

OK, thanks for input re quotes. Will try them somemore.

JDB

On Jul 8, 8:00*pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On Tue, 8 Jul 2008 13:19:24 -0700 (PDT), JDB <jdbNewsGro...@gmail.com> wrote:
> >Sorry, this is a re-post, the first did not show up after 8 hrs. *will
> >try again.
> >--------------------------------------------------------------------------
> >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
>
> Brackets won't help in this case; quotes will: e.g.
>
> "C:\Documents and Settings\Username\My Documents\myspreadsheet.xls"
>
> as a string value will point to the file.
> --
>
> * * * * * * *John W. Vinson [MVP]- Hide quoted text -
>
> - Show quoted text -