NetNews Usenet Archive 1992 #27/NN_1992_27.iso/spool/comp/sys/mac/programm/18482

Internet Message Format | 1992-11-17 | 1.9 KB

Xref: sparky comp.sys.mac.programmer:18482 comp.sys.mac.apps:17276 comp.lang.fortran:4332 comp.os.ms-windows.apps:4944
Newsgroups: comp.sys.mac.programmer,comp.sys.mac.apps,comp.lang.fortran,comp.os.ms-windows.programmer,comp.os.ms-windows.apps
Path: sparky!uunet!ukma!darwin.sura.net!news.udel.edu!me.udel.edu!garrett
From: [e-mail] (Joel J. Garrett; Office 127 CMSL; Phone [phone])
Subject: Can you call F77 subroutines from MS Excel?
Message-ID: <[e-mail]>
Followup-To: comp.sys.mac.programmer
Keywords: fortran excel mac ms-windows
Sender: Joel Garrett <[e-mail]>
Nntp-Posting-Host: me.udel.edu
Organization: University of Delaware
Date: Mon, 16 Nov 1992 22:55:15 GMT
Lines: 22

How difficult would it be to interface a set of existing FORTRAN subroutines
to an Excel Spreadsheet?  Is it possible to somehow include a compiled set of
subroutines and/or functions in an Excel spreadsheet or add-in that could be
called using the regular '=function(arg1,arg2,arg3,...)' convention.  I think
that I recall reading something about being able to call code in DLLs from the
Windows version of Excel (and the MS Fortran compiler now can produce DLLs,
right?), but I mainly need to be able to do this using a Macintosh-based FORTRAN
compiler and Excel.  The reference section of the Excel manuals lists a few
hooks that are supposed to be used for external functions, but they really don't
give any examples or the like, at least not as far as I can see.

Suggestions regarding which FORTRAN compiler would work best for this (on
either platform, Windows or Mac) and how to actually pull it off (if it is even
possible) would be greatly appreciated.  Examples of how to do this in Think C
or Borland C++ would be helpful if it would be possible to extrapolate these
into Fortran solutions.

Please respond via email, I will post a summary if there is interest...

Thanks!
Joel
([e-mail])