Can we use Visual Basic for Applications (VBA) in MS Excel to automate routine tasks with reference to financial analysis ? How ?

Dear Muhammad Ahmed Siddiqui

Excel is written in VB, and if you can write it, then you can write it for any purpose you want. Excel will give you the VB console when you press Alt+F11, now you can write any routine you want. Excel does not know anything about Financial Analysis or Non-Financial Analysis, It is up to you.

I did not know the VB, what I did, I recorded Macros and then I checked the VB of that Macro and then used it in my VB and set my desired routine tasks. What I did was a complete small software for my company, but I found it very slow when my data reached around15000 records.

Thanks

Agree with Mr. Faraz

VBA code written in Microsoft Access can establish references to the Excel, Word and Outlook libraries; this will allow creating an application that runs a query in Access, exports the results to Excel, formats the text, then writes a mail merge document in Word that it automatically e-mails to each member of the original query through Outlook.