VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,872 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In my VBA project the opening of the OLEDB-connection has become really slow.
(In the past it worked fast but since some months it has become slow.)
It takes 13 seconds to just open the connection.
I have tried this with only this coding in my project and only 1 row of data in my excel-sheets so there is no issue regarding big data or complex querying.
This is my code :
Sub ShowData()
Dim connection As New ADODB.connection
'Opening connection
connection.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ThisWorkbook.FullName & _
";Extended Properties=""Excel 12.0;HDR=YES;"";"
'Closing connection'
connection.Close
End Sub