Thread
:
How do i make excel open a new workbook and run a query from sql
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
How do i make excel open a new workbook and run a query from sql
Sounds like you just want a pivot table using an external database.
If you double click on a summary cell in the pivot table, it should produce
a separate sheet with the detail that makes up that summary.
--
Regards,
Tom Ogilvy
"Dhruv Sampat" <Dhruv
wrote in message
...
I would like to create an excel file that would use an odbc connection to
a
database, using microsoft query and return a summarized report. Then i
would
like it to be able to give me the break down, on double clicking a certain
cell of that summary in a new workbook and run a similar sql query to
return
the data for that cell only, using say i clicked on f20, to use a20, b20
and
c20 as inputs for the new query as a pin point query detail.
Any assistance would be appreciated greatly. No matter how small, just
even
opening a new workbook from double clicking on a existing workbook cell
that
has a query behind it.
Thanx in advance.
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy