I'm somewhat new to Access. Thanks for the assist in advance.
I have a database where I would like to graph the results of a query in 
EXCEL. The Graph does not appear well within the Chart function of a report. 
At present I run the query and copy and past into EXCEL and then create my 
chart. 
I would like to place a command on my switchboard menu that will export the 
query to EXCEL.  I know if I can create a macro or a VBA module, I can so 
this from the menu I've created. I have unsuccessfully attempted to create a 
macro and I don't know how to code in order to do export. I would appreciate 
any direction that anyone can provide. Thank you.

Check out TransferSpreadsheet in VBA help. It can be used in VBA or macro; 
it exports a table or query into an EXCEL file.

-- 

        Ken Snell
<MS ACCESS MVP>


"dab1477" <dab1477@discussions.microsoft.com> wrote in message 
news:830343C5-B7DE-4E64-BF7B-3F6BAD3A2D11@microsoft.com...
> I'm somewhat new to Access. Thanks for the assist in advance.
> I have a database where I would like to graph the results of a query in
> EXCEL. The Graph does not appear well within the Chart function of a 
> report.
> At present I run the query and copy and past into EXCEL and then create my
> chart.
> I would like to place a command on my switchboard menu that will export 
> the
> query to EXCEL.  I know if I can create a macro or a VBA module, I can so
> this from the menu I've created. I have unsuccessfully attempted to create 
> a
> macro and I don't know how to code in order to do export. I would 
> appreciate
> any direction that anyone can provide. Thank you.