A
alistair01
This has reallly stumped me!
I have an excel workbook that produces reports based on an access
database. This works fine on my machine but the file is going to be
deployed on others. The problem is that it will still look to make a
connection with the specified path on my machine. I am looking for a
way to make excel look for the database on the pc which it is placed.
The db name will be the same (eventlog.mdb) and the path of the db will
be of the form C:\program files\titan vision\sites\????\event log.mdb.
The only difference is the ????.
Thanks in advance!
I have an excel workbook that produces reports based on an access
database. This works fine on my machine but the file is going to be
deployed on others. The problem is that it will still look to make a
connection with the specified path on my machine. I am looking for a
way to make excel look for the database on the pc which it is placed.
The db name will be the same (eventlog.mdb) and the path of the db will
be of the form C:\program files\titan vision\sites\????\event log.mdb.
The only difference is the ????.
Thanks in advance!