Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute path ??
I've searched and searched to no avail so here is what I am trying t
do. I need make my excel app "portable". I am calling for VB to ope up another .xls and i am wondering if it can be done with .\ vs havin to type in the absolute path, thus having to make sure every user has t 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 folde ? thanks Jo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute path ??
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute path ??
Rich,
Many thanks for making my life much easier in the near future !!! the code worked perfectly. Thanks!!! Joe --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute path ??
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute path | Excel Discussion (Misc queries) | |||
Keep the absolute path in a huperlink | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Absolute vs Relative path | Excel Discussion (Misc queries) | |||
add-in absolute path | Excel Programming |