This e-book shows how to create Excel applications with the SaveToDB add-in and VBA.

As a VBA developer, you may get great benefits and create larger applications in less time.

10 Steps

Here are ten steps described in the book:

  1. Connect to tables, views, and stored procedures
  2. Configure validation lists
  3. Configure ribbon parameters
  4. Translate field, parameter, and object names
  5. Configure formats, formulas, and table views
  6. Configure saving changes
  7. Add cursors and form fields
  8. Create master-detail forms
  9. Configure detail windows and task panes
  10. Configure context and action menus

Example Database

We will create an applicaiton for this sample database:

Table with Foreagn Keys

For example, we will configure an Excel table to edit the underlying table with foreagn keys.

Master-Details in Excel

Also, we will implement the master-detail form with cursors and editable fields in Excel:

Ready-to-use Macros

The e-book contains ready-to-use VBA codes to execute the described steps with VBA:

And much more...

We will do much more. Take a look.

Best regards,

Sergey Vaselenko

Share This