Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
another macro query - deleting a worksheet within a query | Excel Discussion (Misc queries) | |||
Query data from same workbook | Charts and Charting in Excel | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Query returning more data than will fit on worksheet with VBA DB query... | Excel Programming |