Re: Array Declaration Problem ??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Feel free to send my your workbook.
I'd be glad to take a look at it.
- -
Dana DeLouis

1) The FORTRAN code of Zroots() and Laguer() comes from "Numerical Recipes"
by Press et al, pages 366 & 367, as I correctly referenced in my earlier
posts.
The Fortran version works perfectly and as desired in all situations, and I
have hade no problems with it whatsoever!

2) I posted the entire Fortran code of Zroots() and Laguer() here earlier
(total ~ 60 lines), hoping some experts in VBA would help in its conversion
to vba. I subsequently decided to convert the code myself to VBA and have
since posted one of my latest attempts (not sure which one!), which returns
#VALUE!

<snip>

Relevant Pages

  • Re: Using fortran code with VBA
    ... I have done limited programming with both VBA and FORTRAN i.e. ... you use your fortran code in the background. ... Here is my recipe for creating a DLL with g95 that contains a function ...
    (comp.lang.fortran)
  • Re: Using fortran code with VBA
    ... I have done limited programming with both VBA and FORTRAN i.e. ... you use your fortran code in the background. ... What do I need to do after creating "ComputeSquare" in CVF the ...
    (comp.lang.fortran)
  • Using fortran code with VBA
    ... I have done limited programming with both VBA and FORTRAN i.e. ... you use your fortran code in the background. ... What do I need to do after creating "ComputeSquare" in CVF the ...
    (comp.lang.fortran)
  • Re: Transforming Fortran to Excel 2003 Programs
    ... > What is the easiest way to change Fortran to ... > Excel 2003 Spreadsheet programs? ... Create a DLL from the Fortran code and ... is to convert the Fortran program to VBA and to call the VBA code from ...
    (microsoft.public.excel)
  • Is it ok to ask about C++ code / C++ compiler problems on comp.lang.fortran ?
    ... >> to look elsewhere for the source of your troubles as the Fortran ARPACK ... Your problem had something to do with C or the C compiler. ... You can search this in my posts or my emails. ... I used g77 to compile the ARPACK libraries, ...
    (comp.lang.fortran)