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
Macro recording support (Read 4008 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
YaBB Newbies

Posts: 3
Re: Macro Recording
Reply #1 - 09.02.06 at 04:45:54
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.
Back to top
Email   IP Logged
Pages: 1