Installation

The Excel Add-In and the necessary prerequisites, except for Excel, are installed during the installation of Simcenter Amesim. This chapter provides instructions for a manual installation.

Supported platforms

The Simcenter Amesim Add-In for Excel is supported on Windows 10 and 11. It is a standard add-in for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 365.

Installing Simcenter Amesim Add-In for Excel

Follow the instructions below to install the Simcenter Amesim Add-In for Excel. Please read through the instructions before you start.

Procedure

1. Make sure you have one of Excel 2007, Excel 2010, Excel 2013, or Excel 2016 (32- or 64-Bit) installed.

2. Create a new text file using a tool such as Notepad or WordPad.

3. Add the following commands with Copy/Paste.

Copy`@echo off title Excel Add-In installation echo Installing dll

set AME="" set "PATH=%AME%;%AME%\win32;%AME%\win64;%PATH%" set QT_PLUGIN_PATH=%AME%\win64 set QTWEBENGINEPROCESS_PATH=%AME%\win64

REM Microsoft Office 32-Bit version REM The following line installs the 32-bit version: regsvr32 %AME%\win32\ame_treeview_control32.dll REM The following line uninstalls the 32-bit version: REM regsvr32 /u %AME%\win32\ame_treeview_control32.dll

REM Microsoft Office 64-Bit version REM The following line installs the 64-bit version: regsvr32 %AME%\win64\ame_treeview_control64.dll REM The following line uninstalls the 64-bit version: REM regsvr32 /u %AME%\win64\ame_treeview_control64.dll`

Note The set PATH line must be pasted as a single line in your text file.

4. Check the definition of the variable AME at line 5. The path name must correspond to the installation folder of Simcenter Amesim on your computer. Modify it if necessary.

5. Comment or uncomment lines depending on your Excel version (32- or 64-Bit). Other lines must remain commented.

The REM command lets you place a comment in a batch file. The whole line following the REM is ignored. Note You can identify whether your executable is 32 or 64-bit as follows: Start Excel. Open the Windows Task Manager. On the Details tab, locate EXCEL.exe:

The Platform and Architecture columns indicate the version of Excel installed on your machine.

6. Save the file with the file extension .bat, for example, regExcelAddIn.bat.

7. Right-click the BAT file you just created and run it with Administrator privileges. The following window is displayed

Figure 2: Successful installation

Uninstalling Simcenter Amesim Add-In for Excel

Simcenter Amesim Excel Add-In can be uninstalled through the same process as above.

Procedure

1. Right-click the bat file you created in the section above and select Edit.

2. Comment the Install lines for both the 32- and 64-Bit versions. Uncomment the Uninstall line corresponding to your Excel version (32- or 64-Bit). Other lines must remain commented.

regsvr32 /u %AME%\win32\ame_treeview_control32.dll is the command for uninstallation with Excel 32-Bit. regsvr32 /u %AME%\win64\ame_treeview_control64.dll is the command for uninstallation with Excel 64-Bit.

Note The REM command lets you place a comment in a batch file. The whole line following the REM is ignored.

3. Save the file.

4. Right-click the BAT file you just created and run it with Administrator privileges. The following window is displayed

Figure 3: Successful uninstallation