Derivicom's Frequent Questions

Support

Support Programs

Answers to frequent questions that our technical support team receives.

How can I automatically load FinOptions XL every time I start Excel?
It is possible if you follow the steps outlined below.
1. Start Excel, click Tools\Add-ins on the menu bar.
2. Select Browse and navigate to the directory where FinOptions XL was installed. The default directory is C:\Program Files\Derivicom\FinOptions XL.
3. Once in this directory, select the file FinOptions.xla and press OK.
4. Once FinOptions XL has been installed, you will see Derivicom as a new menu bar item.

When I tried to load the sample workbook I got a series of error messages followed by a #NAME in most of the cells. What went wrong and how can I fix this problem?
The Excel Add-in, by default, is installed in the "C:\Program Files\Derivicom\Program Name" directory along with the sample workbook. If the sample workbook and Add-in were moved to separate directories, you will receive this error.

To fix it, follow the steps outlined below.
1. Unprotect each worksheet. To unprotect each, select the sheet and click Tools/Protection/Unprotect Sheet from the menu bar.
2. Click Edit\Links on the menu bar to launch the Link Editor.
3. Select Change Source and navigate to the directory where the program is installed and press OK.

What do I need to do to distribute FinExotics Dev?
1. The FExotics.dll file needs to be installed and registered on the client's computer. The file can be registered with regsvr32.exe, which is located in the system directory.
2. Through code, the AccessKey Property needs to be set to a valid value.

I received a "Run-time error '429' ActiveX component can't create object" error when trying to run the FinOptions Dev Sample. What went wrong and how can I fix this problem?
This error arises from the ActiveX DLL not being registered within the system. When the software was installed the DLL should have been registered.

To fix this problem, follow the steps outlined below.
1. Navigate to the location where the FOptions.dll is located, usually in the
  "C:\Program Files\Derivicom\FinOptions Dev" directory.
2. Double-click the file to register it. If the *.dll extension is not yet associated with an application, the Open With dialog box will appear.
3. Click "Other..." and locate regsvr32.exe on your system to associate *.dll files with regsv32.exe.
4. Once associated, the FOptions.dll library will be registered on your system.

I received a "Compile error: Can't find project or library" error. How can I fix this problem?
This error occurs when the registered DLL is moved from the location where it is registered. A registered DLL has information in the System Registry pertaining to the physical location of the file. If the file is moved, the file's registry information is incorrect. Follow the steps in the preceding question to re-register the FOptions.dll library.

How do I access the FinOptions Dev DLL from Visual Basic?
Once the product has been installed and registered, start a new instance of Visual Basic. Select Project/References to display all of the registered ActiveX DLL's. Select the FinOptions 2.0 Type Library from the Reference list. Then, cut and paste the following into the Form Load event:

   Dim FinOptions As FOptions
   Dim dblResult As Double
   Set FinOptions = New FOptions
   dblResult = FinOptions.GenBS(1, 1, 1, 100.25, 100, 25, 0.3, 0.06, 0.02)
   MsgBox (dblResult)

The Help File seems to need additional files. Which files are required and where can I find them?
The help file requires two system files that are found on more recent operating systems (Windows 98/ NT 4.0 and greater). These files are mfc42.dll and msvcrt.dll. If you do not have these files on your system, you can download them from Derivicom. These files need to be put into the Windows System directory.
Download files: HelpFiles.zip Size: 600k