Hello everybody.
First of all I would apologise if this topic does not belong to this section of forum, for indeed I did not find its proper place. It's about Excel programming in VB.Net language.
Anyway, perhaps you know that there is a set of components named "Access 2010 Database Engine", also a rich platform named "Microsoft Access 2010 Runtime", which can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications, or enables you to distribute Access 2010 applications to users who do not have the full version of Access 2010 installed on their computers. But how about Excel?
Suppose in my VB.Net codes I have the following lines to connect to an Excel workbook:
Dim oExcel As Object = GetObject("", "Excel.Application")
Dim oBook As Object = oExcel.Workbooks.Open(sPrintFile)
Dim oSheet1 As Object = oBook.Worksheets(1)
Well, for end users who do not have the full version of Microsoft Excel Application installed on their computers the above codes would not work and an error will occur and it's normal, for there is no Excel.Application object.
The question is; for a successful "Access Database" connection (OLEDB) in VB.Net applications, installing "Access 2010 Database Engine" will solve the problem and end user does not need to install full version of "Microsoft Access 2010", now for "Excel" programming in VB.Net, which Engine or Runtime we could install instead of full version of "Microsoft Excel 2010"?
Note that I also used Access 2010 Database Engine and it did not solve the Excel problem.
Thanks in advance for any idea.
First of all I would apologise if this topic does not belong to this section of forum, for indeed I did not find its proper place. It's about Excel programming in VB.Net language.
Anyway, perhaps you know that there is a set of components named "Access 2010 Database Engine", also a rich platform named "Microsoft Access 2010 Runtime", which can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications, or enables you to distribute Access 2010 applications to users who do not have the full version of Access 2010 installed on their computers. But how about Excel?
Suppose in my VB.Net codes I have the following lines to connect to an Excel workbook:
Dim oExcel As Object = GetObject("", "Excel.Application")
Dim oBook As Object = oExcel.Workbooks.Open(sPrintFile)
Dim oSheet1 As Object = oBook.Worksheets(1)
Well, for end users who do not have the full version of Microsoft Excel Application installed on their computers the above codes would not work and an error will occur and it's normal, for there is no Excel.Application object.
The question is; for a successful "Access Database" connection (OLEDB) in VB.Net applications, installing "Access 2010 Database Engine" will solve the problem and end user does not need to install full version of "Microsoft Access 2010", now for "Excel" programming in VB.Net, which Engine or Runtime we could install instead of full version of "Microsoft Excel 2010"?
Note that I also used Access 2010 Database Engine and it did not solve the Excel problem.
Thanks in advance for any idea.
Last edited: