Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Adding excel sheet error

I wish to transfer the data from excel sheet to user defind table. When i try to create object of excel sheet it gives error. I am giving some parts of coding & the error:

Dim objExcel As Microsoft.Office.Interop.Excel.Application

Dim objWorkbook As Microsoft.Office.Interop.Excel.Workbook

Dim objWorksheet As Microsoft.Office.Interop.Excel.Worksheet

Error:Type"Microsoft.Office.Interop.Excel.Application" is not defined

I already get the reference of microsoft office to my program...

Former Member
Not what you were looking for? View more on this topic or Ask a question