Excel Mixed Language Sample

This sample requires the 32bit version of Microsoft Excel* as it is not currently supported with 64bit Excel

• Microsoft Visual Studio 2013*, 2015* or 2017* Professional Edition or above
• Intel® Parallel Studio XE 2019 Composer Edition for Fortran Windows* or newer

For Visual Studio IDE users:

1. Open Visual Studio and load the solution .sln file
2. Clean the solution from menu Build > Clean Solution
3. Build the project from menu Build > Build Solution
4. After build complete, the Post build event copies the FCALL.dll from the build directory to C:\TEMP
5. To run the program, open the .\src\xltest.xls spreadsheet by double-clicking on it, enabling macros, then click the button.

For Command line users:

1. Open the Intel Visual Fortran Build Environment window from Start menu and navigate to the sample folder
2. Use following commands to build and test:
   1. Clean the build folder use: build.bat clean
   2. To build a release version: build.bat release
   3. To build a debug version: build.bat debug
   4. To run the program: build.bat run
      this command copies the FCALL.dll to the C:\TEMP folder and copies file .\src\xltest.xls to current ".\" first, and then opens the .\xltest.xls

Because Excel requires an explicit path to the DLL, this has been set as C:\TEMP\FCALL.dll.  If you need to change this, do the following:

1. Right click on the Fcall project in Visual Studio, and select Properties.
2. Click Build Events, then Post-Build Events
3. Edit the Command Line to specify the new destination and click OK.
4. Double-click on xltest.xls. Click Enable Macros when prompted, and then No to open the file for writing.
5. Press ALT-F11 to open the Visual Basic editor.
6. Click the + next to "Modules" and then double-click on Module1
7. Edit the path to the DLL to match what you set in the Fortran project
8. Select File > Close to close the editor.
9. Close Excel and save the file.

Note: As Excel is a 32-bit application, the DLL must also be 32-bit.