up vote 3 down vote favorite
share [g+] share [fb]

I have some data in Access from which I have to create Excel graphs every month (data would also be updated every month). So it's creating the same charts with different data every month.

Is there a way to automate this process? I'm thinking about Excel automatically pulling in the updated data for that month from Access and creating a similar graph to the one created last month (from last month's data) in a new Excel file.

I have the idea that a macro could do this but I don't know how.

link|improve this question
@Duijf Seems we were in the exact same second. Would you like me to roll back or is that fine for you? – slhck Dec 1 '11 at 22:51
@slhck If you think my version is better, then feel free to roll the edit back. It is about helping the OP to achieve the most best possible way to ask a question, not about ego, reputation or anything of that sort. Thanks for asking though, I appreciate it. – Duijf Dec 2 '11 at 19:41
feedback

1 Answer

up vote 0 down vote

I'm not sure why you want to create graphs in Excel since you can create a report in Access and a graph to that or use "Graph Wizard". See the following example

MS Access: Create a graph

If you insist on Excel, I suppose you can save an Excel file with graphs and ODBC data link (Not importing data) as a template and use that to generate the monthly file.

link|improve this answer
I want to automate this process of making graph. I know I can do it in access but I want something (eg: running a sas code or VBA) that would automatically populate it in either access or excel. – Nupur Dec 6 '11 at 15:02
Was the stackoverflow answer by Tony any use? Refer to the following link – Supun Dec 6 '11 at 18:07
I am not a VBA expert. He was really helpful and I tried the code that he provided but I am getting errors and I could not figure out whats mistake I am making. I am looking for a more simple solution. I know SAS very well and thats why I am trying to figure out if I can link SAS to excel to automatically run the code and generate graphs. – Nupur Dec 7 '11 at 17:20
You have not responded to my comments of 7 December against the Stack Overflow version of this question so I do not know if you are still having problems or if you want something different. – Tony Dallimore Dec 28 '11 at 11:56
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.