I think you'll need that extra backslash:

x = ThisWorkbook.path
WorkBooks.Open x & "\database.xls"

rich wrote:

if all files are kept in the same directory regardless of
its name you could use

x = ThisWorkbook.path
WorkBooks.Open x & "database.xls"

-----Original Message-----
I've searched and searched to no avail so here is what I
am trying to
do. I need make my excel app "portable". I am calling
for VB to open
up another .xls and i am wondering if it can be done
with .\ vs having
to type in the absolute path, thus having to make sure
every user has to
have the folder in the same exact place. example:

WorkBooks.Open ".\database.xls"

will this work ?? provided of course all files are in
the same folder
?

thanks
Joe


---
Message posted from http://www.ExcelForum.com/

.


--

Dave Peterson