PC Review


Reply
Thread Tools Rate Thread

Caling fortran from excel

 
 
Rafael Tini
Guest
Posts: n/a
 
      13th Nov 2007
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

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Sm9obiBCdW5keQ==?=
Guest
Posts: n/a
 
      13th Nov 2007
I don't have a clue, but I do have a black belt in google-fu, try these

http://www.canaimasoft.com/f90vb/onl...nual/TH_44.htm
http://support.microsoft.com/kb/123841
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Rafael Tini" wrote:

> 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
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transforming Fortran to Excel 2003 Programs Pranas Rudys Microsoft Excel Discussion 4 13th Jun 2008 08:39 PM
simple c++ dll caling from c# dll Koliber (js) Microsoft C# .NET 5 8th Aug 2007 06:30 PM
how can I import Fortran output to Excel? =?Utf-8?B?QWxp?= Microsoft Excel Programming 1 12th Mar 2005 11:35 PM
Open Excel file through Fortran? aiyer Microsoft Excel Programming 1 2nd Sep 2004 09:54 PM
Calling a Fortran dll from Excel Tom Kreutz Microsoft Excel Programming 0 15th Nov 2003 06:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:56 PM.