Installing C# dll files, reminder

Installing the Frame4 spreadsheet on a new computer I had some problems registering the dll files required for the compiled solver routines, so here is a reminder of the procedure:

  • Copy the alglibnet2.dll and ALMatrixLib.dll files to the appropriate folder (see table below)
  • Run the correct version of the .Net regasm program, which generates a file “ALMatrixLib.tlb”:
    regasm /codebase C:\Windows\System32\ALMatrixLib.dll /tlb
  • Create a reference to the tlb file

There are detailed variations in this procedure, depending on whether the computer is running 32 or 64 bit Windows and Excel, and these are summarised below:

clib3-1

Having registered ALMatrixLib.dll it may be necessary to link to it from the Visual Basic Editor, Tools-References menu:

clib3-2

Note that the registered files appear in the System32 folder, even when they were copied to SysWOW32.

For more details see: Using Regasm.exe and Installing dlls on 64 bit Windows for more details.

This entry was posted in Excel, Frame Analysis, Link to dll, VBA and tagged , , . Bookmark the permalink.

3 Responses to Installing C# dll files, reminder

  1. Excel Help says:

    Thanks for this huge information. This really very helpful.

    Like

  2. Pingback: Frame analysis with spring releases; 2D | Newton Excel Bach, not (just) an Excel Blog

  3. Pingback: 3DFrame with spring releases | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s