Hi,
Am presently using Compaq Visual Fortran (or trying to use it) to create a function that is compiled as a dll. The plan is then to use Excel XP to call this function.
Originally I was using VBA in Excel to do the calcs (which at the time was adequate), although now Fortran dlls is what is required by my boss. Could someone just give me quick bit of Fortran code to perform the Sine of a number for example, and then the VBA command to define the function in Excel? I can hopefully go on from there to do the calcs that are required - just an example of calling a dll would be great.
Any help on this would be appreciated as I keep getting "Can't find entry point"/Excel crashes amongst other things and I'm starting to tear my hair out!!!!
Many thanks,
BFG
Am presently using Compaq Visual Fortran (or trying to use it) to create a function that is compiled as a dll. The plan is then to use Excel XP to call this function.
Originally I was using VBA in Excel to do the calcs (which at the time was adequate), although now Fortran dlls is what is required by my boss. Could someone just give me quick bit of Fortran code to perform the Sine of a number for example, and then the VBA command to define the function in Excel? I can hopefully go on from there to do the calcs that are required - just an example of calling a dll would be great.
Any help on this would be appreciated as I keep getting "Can't find entry point"/Excel crashes amongst other things and I'm starting to tear my hair out!!!!
Many thanks,
BFG