View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.