Hi expert/members,
I have a situation here, I have an excel file, there one of the sheet contains a button. In mannual way, i will have to open the excel file go to the excel sheet and mannually trigger the button.
However now i have converted it that i wanted to use asp.net to auto trigger the excel sheet button.
I uses this method
excelApp = New Excel.Application
excelWorkBook = excelApp.Workbooks.Open(myFile)
excelApp.Run("Macro_runBtn")
excelWorkBook.Close(False)
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelWorkBook)
...
Go to the complete details ...