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
Fully automate report generation with SQL*XL (Read 2871 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Fully automate report generation with SQL*XL
16.01.08 at 22:09:11
 
Fully automate report generation with SQL*XL
 
The report I am prototyping aims to add extra worksheets on a daily basis and a new summary column on a daily basis. I have develop4ed a VBA macro to do most of the work however is there anyway to call the SQL*Xl run function from VBA to fully automate the report generation?
 
Answer:
Sure it can.  
 
Did you know SQL*XL supports macro recording? Just record away while you use SQL*XL. The created SQL*XL code can be modified later. The API is decribed in the help files.
 
www.oraxcel.com/projects/sqlxl/help - the SQL*XL files
www.oraxcel.com/forums - the SQL*XL forums
Back to top
 
« Last Edit: 16.01.08 at 22:12:56 by Gerrit-Jan Linker »  

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