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
Changed macro syntax (Read 4769 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Changed macro syntax
23.12.05 at 09:42:24
 
With improvements in SQL*XL it is sometimes necessary to change the syntax of the macro code. This topic is intended to publish the syntax changes.
 
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Changed macro syntax
Reply #1 - 23.12.05 at 09:44:17
 
Property StartInCell of Target Excel has changed to a String property.
 
Previous syntax: Set Targets(litExcel).StartInCell = Range("A1")
New syntax: Targets(litExcel).StartInCell = "A1"
Back to top
 
« Last Edit: 23.12.05 at 09:44:39 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Changed macro syntax
Reply #2 - 23.12.05 at 11:09:17
 
Property Index of the Statement objects were removed. Hitherto you could use the Index property to get the location of the statement in the Statements collection. This is now no longer possible. With the support for T-SQL returning recordsets new "Statements" will be inserted into the collection. This means we loose the ability to refer to the Index property.
 
Further, when looping the statements collection please use the Statements.Count property.  
Do not use this technique anymore:
For each statement in SQLXL.SQL.Statements
Use the following technique instead
For lngStatement = 1 To  SQLXL.SQL.Statements.Count
Back to top
 
« Last Edit: 23.12.05 at 11:09:54 by Gerrit-Jan Linker »  

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