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

Problems with dll and vba (excel)

andreti
Beginner
‎10-19-2006 12:42 AM
1,302 Views

I compiled with Intel Visual Fortran a DLLto do some mathematical computation. I called this dynamic-library from visual basic in excel. I haved some initial issues, butI read in this forum all the information regarding the comunication between the programminglanguages. So I use the !DEC$ ATTRIBUTES DLLEXPORT,STDCALL,REFERENCE statement and everything worked fine.

But when i define a local allocatable variable inside the dll, when i call the subroutine from excel, nothing happens and i get a #VALUE! error.

What is the problem? Please help me.

0 Kudos

Link Copied

1 Reply
Nick2
New Contributor I
‎10-19-2006 05:04 PM
1,302 Views
Have you tried calling your function from a Fortran program, to see if your function runs fine on its own?
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.