I have the following problem...
I have developed an application in Microsoft Access 97. I then make use of a TransferSpreadsheet macro to transfer the data from MS Access 97 to MS Excel 97 to produce a histogram.
I use the data imported from MS Access to get the Bin and Frequency (using the Data Analysis menu option of MS Excel)to be plotted on the Histogram.
I have successfully managed to get the desired result except that when I update the data in MS Access, the Bin and Frequency values are not automatically refreshed and neither the Histogram to reflect the updated data.
The data in MS Excel is updated after the TransferSpreadsheet macro is executed again.
Is there anyway of automatically updating the Bin and Frequency values and the Histogram without having to go to the Data Analysis menu option of MS Excel?
I hope this explanation makes sense. Don't hesitate asking for further clarification of the problem.
Thanks and regards.