Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Caling fortran from excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rafael Tini - 13 Nov 2007 16:10 GMT
Hi, i'm new at using fortran and vba, and i'm trying to covert an old
progran that i found to a dll, so i can pul it from microsft execel,
with the elp of vba.
but i'm having some problens and got lost on how to do this, so i
would like a little help from you.
the variables that i want to pass are

     READ(10,*) TFRE
     READ(10,*) TFRS
     READ(10,*) HFR
     READ(10,*) CPFF
     READ(10,*) TFAE
     READ(10,*) TFAS
     READ(10,*) HFA
     IF(TFAE.EQ.TFAS) THEN
      READ(10,*) DENSVAP
     END IF
     READ(10,*) CPFA
     READ(10,*) NCOR
     READ(10,*) DTM
     READ(10,100) ((A(L,K),L=1,5),K=1,NCOR)
100  FORMAT(F25.12)
     READ(10,*)
     READ(10,101) ((PROJ(L,K),L=1,6),K=1,NCOR+2)
101  FORMAT(F25.12)
     READ(10,*)
     READ(10,112) (ESTA(L),L=1,NCOR)
112  FORMAT(F25.12)

they are declared on the code as doulbe precision and dimension.

what i should change , and what lines should i add to the code so i
can create the dll

also, how should the vb code be  stated?

if you guys could provide me some lnks to other exemples i would
really apreciate, because i need to pass a lot of arrays and single
vars.
thank you for the help
John Bundy - 13 Nov 2007 20:45 GMT
I don't have a clue, but I do have a black belt in google-fu, try these

http://www.canaimasoft.com/f90vb/onlinemanuals/usermanual/TH_44.htm
http://support.microsoft.com/kb/123841
Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> Hi, i'm new at using fortran and vba, and i'm trying to covert an old
> progran that i found to a dll, so i can pul it from microsft execel,
[quoted text clipped - 36 lines]
> vars.
> thank you for the help
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.