concatenate in the path from the activeworkbook. Something like :

SELECT [everything$].ID, [everything$].UID, ...
FROM `" & activeworkbook.path & "\`.[everything$] [everything$]

Peter Richardson

"Baglog" wrote:

Hi Everyone,

I am creating an excel workbook that I would like to distribute to others.
This workbook uses another excel workbook as the data source. Currently, the
select statement looks like this:

SELECT [everything$].ID, [everything$].UID, ...
FROM `C:\path\export`.[everything$] [everything$]

What I would like to accomplish is remove the "C:\path" part and have the
query look for the data store in the same directory as the workbook. This
should allow me to zip up the file and the data store and distribute it to
others with the instructions to just overwrite the the data store with more
current information.

I have changed the FROM line to read:
FROM `export`.[everything$] [everything$]

and I get an error: Could not add the table '`export`.[everything$]'.

Is there a graceful way to accomplish this? My backup plan is to just force
the users to use a hard-coded directory (small user community), but I'd like
to shoot for something a little bit more flexible.

Thanks in advance!