Intel® Fortran Compiler
Build applications that can scale for the future with optimized code designed for Intel® Xeon® and compatible processors.
29427 Discussions

Excel + Fortran

cholack
Beginner
‎02-02-2003 01:17 PM
884 Views
Following Ribar's "Fortran Programming for Windows" (1993)(Perhaps the book is not suitable, it looks to be for Windows 3.0 only) I am trying to build an Excel front driver for Fortran DLL, but everything goes wrong. I am using Excel 2000 and 2002 and CVF 6.1. Could you suggest something?
0 Kudos

Link Copied

2 Replies
Intel_C_Intel
Employee
‎02-02-2003 02:24 PM
884 Views
The book seems to be outdated. Presumably the easiest way to deal with Excel/Fortran is through Canaima f90SQL . At the webpage you'll find some examples etc. The "lite" version is included with CVF 6.6. (and 6.5). The search in this forum itself gives a lot of good tips about many related issues. As far as Windows/Fortran goes a good start could be Compaq Visual Fortran: A Guide to Creating Windows Applications (details here)
A.
0 Kudos
Copy link
Intel_C_Intel
Employee
‎02-03-2003 02:44 PM
884 Views
I would look in Fortran help under Programming with Mixed Languages. You can apply the references to Visual Basic/Fortran mixed language programming to VBA. You can use VBA in Excel to create a function that calls a Fortran .dll.
0 Kudos
Copy link
Reply

Community support is provided Monday to Friday. Other contact methods are available here.

Intel does not verify all solutions, including but not limited to any file transfers that may appear in this community. Accordingly, Intel disclaims all express and implied warranties, including without limitation, the implied warranties of merchantability, fitness for a particular purpose, and non-infringement, as well as any warranty arising from course of performance, course of dealing, or usage in trade.

For more complete information about compiler optimizations, see our Optimization Notice.