Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Other VBA uses
|
|
|
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. |
Other VBA uses
Resolved · Low Priority · Version 2007
Reply Tue 13 Dec 2011, 16:40Delegate Ian said...
Ian has attended:
Excel VBA Intro Intermediate course
Other VBA uses
As well as with pivot tables and forms, what else can VBA help you with?
For upcoming training course dates see: Pricing & availability
RE: Other VBA uses
Hi Ian,
Thank you for your question.
VBA can be used to import multiple files such as csv files and then format and run calculations on the data. You would create an array(Variable that holds multi dimensional data held in memory so processing calculations are quicker than on the sheet) create the extra calculatiosn and then output the data to a physical excel spreadsheet.
A lot of people build routines to export data from each sheet to a report in MS Word to print off for meetings.
There are routines to search for files by part of name and date and then find the files and email them.
I hope this helps.
Regards
Simon
Wed 28 Dec 2011: Automatically marked as resolved.
|