Local Directory File Access

Hello all,

I am trying to get a macro to open a file in the same directory as the xl
file being launched. The code I am using is:
Workbooks.Open Filename:="DB-Data.xls"

For some reason it doesn't want to find it [although the help file says that
it should]. If I give it a full path, it has no problem. Is it possible to
do this? My goal is to get these workbooks available on CD for people to
work at home.

Thanks,
-=Alejandro

Thisworkbook.path

will give you the path to the workbook running the code...
--
HTH...

Jim Thomlinson


"Alejandro" wrote:

> Hello all,
>
> I am trying to get a macro to open a file in the same directory as the xl
> file being launched. The code I am using is:
> Workbooks.Open Filename:="DB-Data.xls"
>
> For some reason it doesn't want to find it [although the help file says that
> it should]. If I give it a full path, it has no problem. Is it possible to
> do this? My goal is to get these workbooks available on CD for people to
> work at home.
>
> Thanks,
> -=Alejandro
>
>
>

Jim,

Thanks for the suggestion! That helped a lot. It works now, with the
addition of a '\' in front of the file name in the code, as such:
Workbooks.Open Filename:=(ThisWorkbook.Path & "\DB-Data.xls")

It worked great!

-=Alejandro

"Jim Thomlinson" <[email protected]> wrote in message
news:[email protected]...
> Thisworkbook.path
>
> will give you the path to the workbook running the code...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Alejandro" wrote:
>
>> Hello all,
>>
>> I am trying to get a macro to open a file in the same directory as the xl
>> file being launched. The code I am using is:
>> Workbooks.Open Filename:="DB-Data.xls"
>>
>> For some reason it doesn't want to find it [although the help file says
>> that
>> it should]. If I give it a full path, it has no problem. Is it possible
>> to
>> do this? My goal is to get these workbooks available on CD for people to
>> work at home.
>>
>> Thanks,
>> -=Alejandro
>>
>>
>>