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 recording support (Read 4063 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Macro recording support
04.06.07 at 20:48:31
 
Macro recording support
 
SQL*XL actions can be automated using the standard Excel VBA macro language. You don't need to learn the syntax. Just record a macro when doing some SQL*XL database work. Then inspect the code if you want to make any changes. The SQL*XL API is written up in the API reference, handy if you want to change anything.
 
With the SQL*XL macro recording support you can write you own small utilities. You can even hide the SQL*XL interface and replace it with your own. Just record the actions you want to automate and provide a button or a menu item for your users to use.
 
When you want to start using the SQL*XL macro recorder you need to enable it from the program preferences.
 
Depending which version of Excel you use you may be asked whether you want to give SQL*XL access to the Visual Basic Projects. This is necessary for the macro recording support to work.  
 
Further reading:
Back to top
 
« Last Edit: 07.06.07 at 09:15:08 by Gerrit-Jan Linker »  

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




Posts: 3
Re: Macro Recording
Reply #1 - 09.02.06 at 04:45:54
 
Gerrit-Jan,
 
Thanks. I think what we did not do was to install the Thawte Code Signing Root Certificate. I presume that this is a mandatory step before the security setup allows for macro recording.
 
TT
Back to top
 
 
Email   IP Logged
Pages: 1