Hello I am using this code to call Excel macro which I copied from Microsoft knowledge. However,
it actually open>run macro > Close. I have to repeat this Macro very quickly for many times and in fact
I have already have the Excel file active when the web server starts so the open & close action is undesirable
in my case and it is causing serious delays due to performance issue. How to trim this code to just simply run the Macro1 on ABC.XLS without open/close ?
Thanks in advance
===================
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim oExcel As Excel.ApplicationClass
Dim oBook As Excel.WorkbookClass
Dim oBooks As Excel.Workbooks
'Start Excel and open the workbook ...
Go to the complete details ...