In this post I tried to explain about, how to work with the macro enabled excel sheet. Macro enabled excel use VBA (Visual Basic for Application) for functional purpose in excel sheets. This post is a part of my Retrieve data from excel file in code behind .
1. Import library into your application. I assign a name to that library for working easily.
2. Assign a values
3. Get the procedure name which use into your VBA code.
Macro name is the combined of component name and procedure name. So you must concatenate this ComponentName and procedureName which I used in this application.
4. Application.Run method help to update your changes in your application.