Thisworkbook.path
will give you the path to the workbook running the code...

Signature
HTH...
Jim Thomlinson
> Hello all,
>
[quoted text clipped - 9 lines]
> Thanks,
> -=Alejandro
Alejandro - 31 Mar 2006 23:29 GMT
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
> Thisworkbook.path
>
[quoted text clipped - 15 lines]
>> Thanks,
>> -=Alejandro