D
darrin.london
I have an Access tool that takes data from various files and creates
graphs based on the imported data. I set up the tool to have a message
box asking the user if they would like to export the graphs to excel.
If the user hits yes, the graphs are created in Access on forms and as
these forms are opened, the code runs a copy and paste special function
to export the graph into excel. My problem comes in when data is
updated and I try to export the graphs. I cannot find the right event
to put the copy code to get the latest version of the graph with the
updated data. Currently, if I update data, the code copies the old
version of the graph. Does anyone have any ideas?
Thanks in advance,
Darrin London
graphs based on the imported data. I set up the tool to have a message
box asking the user if they would like to export the graphs to excel.
If the user hits yes, the graphs are created in Access on forms and as
these forms are opened, the code runs a copy and paste special function
to export the graph into excel. My problem comes in when data is
updated and I try to export the graphs. I cannot find the right event
to put the copy code to get the latest version of the graph with the
updated data. Currently, if I update data, the code copies the old
version of the graph. Does anyone have any ideas?
Thanks in advance,
Darrin London