ASP.NET - .dll provides functionality of excel vba support other than Excel.Inte

Asked By balaji on 04-Jun-12 05:25 AM

hi frds

.dll provides functionality of excel vba support other than Excel.Interop

pls help

dotnet freak replied to balaji on 04-Jun-12 05:28 AM

Please follow below link:
http://www.vb-helper.com/howto_use_vb_dll_in_excel.html

Jitendra Faye replied to balaji on 04-Jun-12 05:31 AM

If you don't want to use Excel InterOP the you can use OpenXml SDK.

this will allow you to integrate VBA code with Excel.

follow this link-

http://stackoverflow.com/questions/8331711/c-how-to-inject-vba-code-into-excel-xlsm-without-using-vba-project-object-mod

Hope this will help you.