Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Run-time error 424: Object required (Read 8526 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Run-time error 424: Object required
28.11.05 at 14:43:35
Mike from the UK asked the following question:
I'm having problems connecting within a VBA macro using this code
Private Sub Connect()
  SQLXL.Database.ConnectionType = litOO4O
  SQLXL.Database.Connect UserName:="scott", Password:="tiger", DBAlias:="oracle", ConnectionString:=""
End Sub

The likely reason why this is failing is that you have forgotten to set a reference to SQL*XL. When you record a macro, which is the preferred method to make your own code, a reference is automatically added. You can add a reference manually too. Please read this topic on how to add a reference to SQL*XL manually:
Also see:
Compile error: can't find project or library;action=modify;messag e=0;thread=1187088411
Back to top
« Last Edit: 14.08.07 at 12:48:58 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1