Guinaba
Board Regular
- Joined
- Sep 19, 2018
- Messages
- 218
- Office Version
- 2016
- Platform
- Windows
Hi guys,
I am trying to get the data from a .xlsb file using ADODB but keep getting the error below:
Run-time error '446':
Object doesn't support named arguments
I've activated the Microsoft ActiveX Data Objects 6.1 Library and I am using Excel16 64bit. Any suggestions?
I am trying to get the data from a .xlsb file using ADODB but keep getting the error below:
Run-time error '446':
Object doesn't support named arguments
I've activated the Microsoft ActiveX Data Objects 6.1 Library and I am using Excel16 64bit. Any suggestions?
VBA Code:
Sub GetDataFromClosedFile()
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.ConnectionSting = _
"Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=S:\Everyone\Demand Planning\Primary & VE\Woolworths\WW Daily Scan Sales\Daily Sales 20210708.xlsb;" & _
"Extended Properties='Excel 12.0 ;HDR=YES';"
cn.Open
cn.Close
End Sub