Excel-DB. Rapid Database Spreadsheet Analysis. Rapid Database Spreadsheet Analysis  


Excel-DB Help

Starting Excel-DB

To use Excel-DB in Excel you need to manually launch Excel-DB once so it can add the Excel-DB toolbar and menu to Excel. After that you can use Excel-DB simply by starting Excel and by using the Excel-DB menu or toolbar.

To start Excel-DB for the first time use one of the following methods:

Start Excel-DB from your computer's Start menu:

Click Start | Programs | EXCELDB | EXCELDB

This will start Excel and load the Excel-DB module. If you have Excel already open it will just add the menu and toolbar. To use Excel-DB simply click the Excel-DB menu or click on the connect icon in the Excel-DB toolbar.


Start Excel-DB by double clicking EXCELDB.xla:

In Windows Explorer find the Excel-DB installation directory (usually c:\program files\EXCELDB) and double click on the EXCELDB.xla file.

This will start Excel and load the Excel-DB module. If you have Excel already open it will just add the menu and toolbar. To use Excel-DB simply click the Excel-DB menu or click on the connect icon in the Excel-DB toolbar.


Start Excel-DB from Excel:

In Excel use File|Open and open the EXCELDB.xla file from the Excel-DB installation directory (usually c:\program files\EXCELDB).

This will load the Excel-DB module and add the Excel-DB menu and toolbar. To use Excel-DB simply click the Excel-DB menu or click on the connect icon in the Excel-DB toolbar.
 

Excel-DB Security warnings


On first use Excel will display a warning that you are trying to start a file with macros.

For more information about the digital signature please see the digital signature topic in the trouble shooting section.

To not get this annoying question again find instructions below:

Excel 97 users:

You can simply click Yes to indicate that you trust Excel-DB. Excel will not ask you this again.

Excel 2000 users:

Click "Enable Macros" to indicate that you want to start Excel-DB from Linker IT Software BV(my company name). If you check the "Always trust macros from this source) box Excel willnot ask you this again. If you do not check the box Excel will ask you this again each time you use Excel-DB.

Excel 2002 (XP) & 2003 users:

Click "Enable Macros" to indicate that you want to start Excel-DB from Rampant TechPress (my company name).

If this option is grayed out Excel's security will be set to high. Set it temporarily to medium to specify that you trust Excel-DB. Simply set security back to high again when you have indicated to trust Excel-DB.
Do not set the security to very high as that prevents all macros from being executed.

In Excel go to Tools|Options|Security|Macro Security.

If you check the "Always trust macros from this source" box Excel willnot ask you this again. If you do not check the box Excel will ask you this again each time you use Excel-DB.


 



 

Excel-DB
A Division of Rampant TechPress
P.O. Box 511 . Kittrell, NC . USA .

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.