ASAP Utilities manual installation in Excel 2007

Step 1

Place all the ASAP Utilities files on you hard drive. It doesn't matter what the location is, as long as all the files in the package are together.
The recommended location is: C:\Program Files\ASAP Utilities\

Step 2

Register the ASAP Utilities library DLL. For this part you need administrator or power user rights.

1. Close all open programs.
2. Click Start on the Windows taskbar, click Run, and then type the following:
   
   Regsvr32.exe "<Install Path>\asap_utilities.dll"
   for example:
   
   Regsvr32.exe "C:\Program Files\ASAP Utilities\asap_utilities.dll"
3. Press Enter, or if you use Windows Vista, press Control+Shift+Enter
   The following message should appear: DllRegisterServer in <Install Path>\asap_utilities.dll succeeded.

Step 3

Start Microsoft Excel and click on the upper-left icon.
Then click on the "Excel Options" button:

Step 4

Choose Add-Ins:

Step 5

Press the "Go..." button to manage the Excel add-ins:

Step 6

Click on the browse-button in the Add-Ins dialog to locate the ASAP Utilities.xla file
(by default in the folder C:\Program Files\ASAP Utilities\)
If Excel asks you to copy the file to the library folder, always answer "no". (this is important)

Step 7

Check the "ASAP Utilities" check box and press the OK-button. When you do that ASAP Utilities will be started. The first time it will register the file ASAP_Utilities.dll.

Step 8

In menu you will now see a new tab: "ASAP Utilities".
If you do not see ASAP Utilities in the menu you have to close and restart Excel.
Installation is now finished. Have fun!

Read our User Guide with tips and tricks

I recommend you to read our User Guide to get the best out of ASAP Utilities.

DLL registration, administrative privileges

You must be logged in as an administrator or as a member of the Power Users group when installing ASAP Utilities . When the installation is finished every user on the computer is able to use ASAP Utilities.
Some systems do not allow certain sections of the registry to be written to by users without administrative privileges. It is recommended that only those with administrator privileges and those that are logged on as administrator install ASAP Utilities on such a computer.
The file "ASAP Utilities.dll" is registered as ActiveX (COM) component on the machine, using the HKEY_LOCAL_MACHINE registry entry. That means that to register the add-in you need to be a member of the "Administrators" or "Advanced Users" groups. ASAP Utilities creates the following key. This way all users on the computer can work with ASAP Utilities. If you choose the manual installation the DLL is registered the first time you start Excel with ASAP Utilities.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\ASAP_Utilities.adConnect