calling stored procedures from EXCELL using Visual Basic For Applications
Can EXCELL call an AS/400 Stored Procedure Using Visual Basic For Applications? Get: "user defined type not defined" for: Dim Con1 As New ADODB.Connection Any help is appreciated.
calling stored procedures from EXCELL using Visual Basic For Applications
It sounds to me like your vba project does not have a reference to the OLEDB provider. From the VB Editor, select Tools|References and pick the OLEDB provider from the list.
Tweet
Comment