using worksheet in same workbook for query
Due to an "unusual" situation, I have had to setup a workbook as an RDBMS.
worksheets are treated as tables.
Using the MS-Query functionality in excel, everything works fine except when
I try to send the file to other people, the workbook is unable to reference
itself as the source of the MS-Query and I think looks for the absolute path
of the file on my machine.
Is there a way to point to the same worksheet "relatively"?
Hope I'm making sense :) thanks in advance
|