Linker IT Software
Google
Web www.oraxcel.com
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
Macro language support (Read 4197 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Macro language support
23.04.07 at 20:15:55
 
Macro language support
 
Question:
What sort of macro-language support is available for SQL*XL?  Can it be driven by the available macro language facilities in Excel?
 
Answer:
The VBA macro language as it is natively present in Excel is supported by SQL*XL. SQL*XL can be driven from VBA in Excel. Moreover, SQL*XL can also record VBA code through the Excel macro recorder.
 
As an example please see the following recorded code  
 
Private Sub Connect()
'
    SQLXL.InitialiseSQLXL
    SQLXL.Database.ConnectionType = litOO4O
    SQLXL.Database.Connect UserName:="scott", Password:="tiger", DBAlias:="oracle", ConnectionString:=""
End Sub
Back to top
 
 

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