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