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:
Pages: 1