• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

Visual Basic connect to Excel file

In order ro connect the Excel file will I need Excel installed on my computer.
See code below.

Private m_oXlsTests As ADODB.Connection
Private m_oRdsTest As ADODB.Connection

   Set m_oXlsTests = New ADODB.Connection
    With m_oXlsTests
        .Provider = "Microsoft.Jet.OLEDB.4.0"
        .Properties("Extended Properties") = "Excel 8.0"
        strFileName = App.path & "\Tests.xls"
        .Open strFileName
    End With
0
Idarac
Asked:
Idarac
1 Solution
 
Rory ArchibaldCommented:
No, that should not require Excel.
0
 
shorvathCommented:
You do not require Excel to be installed on a system in order to use ADO to read and write data in Excel workbooks.

http://support.microsoft.com/kb/278973

For a detailed article using VB6 ADO and Excel see this link:

http://support.microsoft.com/kb/257819
0
 
IdaracAuthor Commented:
Perfect
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now