How do i make excel open a new workbook and run a query from sql
 

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.

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.

How do i make excel open a new workbook and run a query from sql
 

Tom, Could you show me a sample script or direct me to how that can be done?

"Tom Ogilvy" wrote:

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.

How do i make excel open a new workbook and run a query from sql
 

See Debra Dalgleish's site for information on Pivot Tables:

http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy

"Dhruv Sampat" wrote in message
...
Tom, Could you show me a sample script or direct me to how that can be
done?

"Tom Ogilvy" wrote:

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.