Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Graphs and Storing Input Data and Outputs
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Graphs and Storing Input Data and Outputs
Resolved · Medium Priority · Version 2007
Reply Tue 6 Dec 2011, 16:13Delegate Ioanna said...
Ioanna has attended:
Excel VBA Intro Intermediate course
Graphs and Storing Input Data and Outputs
I would please like to know more about:
(1) creating charts
(2) ways of storing input and output data separately when i'm using an excel workbook as a calculation tool. the aim of this would be to keep the size of the tool small and to keep a record of input and output data for future references. also, could these be automatically stored into an access database? is this the best way to store input and output data after they have been used/produced?
Thank you!
For upcoming training course dates see: Pricing & availability
RE: Graphs and Storing Input Data and Outputs
Hi Ioanna,
Thank you for your question and welcome to the forum.
Please find some chart code attached to this email which will help you.
I will pass the second request to a colleague of mine who will be in a better position to assist you.
Regards
Simon
Attached files...
Outlook word and chart code.docReply Fri 9 Dec 2011, 12:44Delegate Ioanna said...
RE: Graphs and Storing Input Data and Outputs
Hello Simon,
Thank you very much for such a quick and helpful response. I'll have a go!
Regards,
Ioanna
RE: Graphs and Storing Input Data and Outputs
Hi Ioanna, thanks for your query. Automatically storing the input and output data in an Access database is certainly possibly but a bit involved. It not only involves coding the connection to the database but also attaching that to the Worksheet_Change event of the spreadsheet itself. We cover material of this nature on our Advanced Excel VBA course and a conversation about what you want to achieve would be a good idea then.
Hope this helps,
Anthony
|