98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Graphs and Storing Input Data and Outputs | Excel forum
Graphs and Storing Input Data and Outputs | Excel forum
Resolved · Medium Priority · Version 2007
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!
Fri 9 Dec 2011, 10:29Trainer Simon said...
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.docFri 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
Mon 12 Dec 2011, 09:48Trainer Anthony said...
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
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. |
Excel tip:Use Paint Brush to Format More than one CellTo copy a format to many cells or ranges |
