hi
I have some data in a multiuser db that i want to create a graph from. What i am doiing is exporting the data in excel with some code, and manually creating the graph in excel.
What i want to do is write some code in access that will create the grah automatically.
I thought about creatin a macro in excel and run it when i needed to. But the problem with that method is that the macro is over written evert time i export data to excel. Also i did not want people to add the macro in excel to their personl file in excel.
Can anyone help?
thanx in advance.
I have some data in a multiuser db that i want to create a graph from. What i am doiing is exporting the data in excel with some code, and manually creating the graph in excel.
What i want to do is write some code in access that will create the grah automatically.
I thought about creatin a macro in excel and run it when i needed to. But the problem with that method is that the macro is over written evert time i export data to excel. Also i did not want people to add the macro in excel to their personl file in excel.
Can anyone help?
thanx in advance.