automated transfers

[ben]

I have a large access database that i want to have a
graphical display on a report. I want to be able to set
it up so i can click a button and produce an excel chart
on the report. From what I understand, this will involve
exporting the data from access to excel, graph the data
in excel, and export the graph back to Access.

I would like to know if this can really be done...i have
been working on it for a week and am getting really
frustrated. If anyone has any suggestions please let me
know.

Thanks
Ben

 

[ben]

I am a college student working for a company this summer
who had their Access guy up and quit...so i'm stuck
fixing what he left hanging. I am getting stuck on
getting started...I have used Access for about 3 weeks
now and have never dealt with VBA code. I was told in an
access newgroup that this COULD be done, but they didn't
know how.

If you could help me with where this code needs to be
inserted, and possibly which lines need to be modified to
fit my application...i would be in debt to you...

Thank you for your help and continued support...
Ben

 

[Debra Dalgleish]

You'd store this code on a module. To create a module, go to the
Database window (press F11), then choose Insert>Module.

Paste in the code, then click the Save button, and name the module.

Change the variables to match your database. For example, I used data
from a query (strQry = "qryBilledAmount"), but your data may be from a
different source.

If you aren't creating a line chart, you could record the steps in
Excel, for the type of chart that you want to create, then use that in
the Access code.

To run the code, you can add a command button from the toolbox. Open the
properties window, and in the button's OnClick event, add an event
procedure. Type the name of the procedure, e.g.:

Private Sub cmdChart_Click()
ChartExcel
End Sub