View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JayPee JayPee is offline
external usenet poster
 
Posts: 12
Default 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