Believe me it is a child play!!
Yet the result will be an Expert Solution!!!
If you know EXCEL operations very well, you can code for the same. For example, you may wish to subtotal the EMP records based on DEPT. (Refer my previous Blog Post for programmatically fetching data from ORACLE to EXCEL Worksheet).
You know using DATA / SUBTOTAL menu. If you want to do the same from a EXCEL VBA macro, then You need not learn EXCEL VBA language. Here is the shortcut.
Procedure
----------
- Start recording macro. (TOOLS / MACRO / RECORD NEW MACRO)
- Now you can start working as usual. In this case you find the subtotal of the EMP records based on DEPT.
- Stop recording macro (TOOLS / MACROS / STOP RECORDING)
- Now Start VBE (Visual Basic Editor) (TOOLS / MACROS / Visual Basic Editor)
- In the Project Explorer, Expand the Modules. You can see 'Module1'. Open the 'Module1' by double clicking it.
- VOILA!!! You can see the code for finding subtotal.
- COPY, PASTE and CUSTOMIZE
If you ask me what is EXCEL-VBA programming!!!
for a NOVICE Programmers
RECORD, COPY, PASTE and CUSTOMIZE
For Advanced Programmers
Will tell in the subsequent posts. Keep visiting my Blog.
