Dll for Excel
in [Fortran]
|
From: richard symonds on 20 Mar 2006 19:17 I need a little help - having never done this before. I want to create a dll for an Excel add-in. How do I do this? Is there a tutorial or site someone can direct me to/ Thanks
From: Steve Lionel on 20 Mar 2006 20:56 richard symonds wrote: > I need a little help - having never done this before. I want to create a > dll for an Excel add-in. How do I do this? Is there a tutorial or site > someone can direct me to/ Drop by the Intel Visual Fortran forum at http://softwareforums.intel.com/ and we can steer you in the right direction. The fundamentals are that the routine has to have the STDCALL calling convention and you need to fully describe the DLL name, routine name and arguments in the Excel macro module. Steve Lionel
From: richard symonds on 20 Mar 2006 21:41 I was hoping to avoid the use of VBA and use and Excel add-in *.xla. I looked at the forum briefly and could nit find material that touched xla's. Should I ask the question in that forum or look elsewhere? "Steve Lionel" <Steve.Lionel(a)RemoveMeIntel.com> wrote in message news:U2JTf.15528$S25.10712(a)newsread1.news.atl.earthlink.net... > richard symonds wrote: >> I need a little help - having never done this before. I want to create a >> dll for an Excel add-in. How do I do this? Is there a tutorial or site >> someone can direct me to/ > > Drop by the Intel Visual Fortran forum at > http://softwareforums.intel.com/ and we can steer you in the right > direction. > > The fundamentals are that the routine has to have the STDCALL calling > convention and you need to fully describe the DLL name, routine name and > arguments in the Excel macro module. > > Steve Lionel
From: richard symonds on 20 Mar 2006 22:02 OK - As I look at more information - it may be that the xla needs to be formed within Excel VBA code and then saves as an xla which is then transportable as an add-in file. If this is true, then I guess I do need to use the VBA and get the functions to work within Excel before moving to the VBA. Can this be confirmed? "richard symonds" <richardsymonds(a)charter.net> wrote in message news:sJJTf.576$f85.441(a)fe05.lga... >I was hoping to avoid the use of VBA and use and Excel add-in *.xla. I >looked at the forum briefly and could nit find material that touched xla's. >Should I ask the question in that forum or look elsewhere? > > "Steve Lionel" <Steve.Lionel(a)RemoveMeIntel.com> wrote in message > news:U2JTf.15528$S25.10712(a)newsread1.news.atl.earthlink.net... >> richard symonds wrote: >>> I need a little help - having never done this before. I want to create >>> a >>> dll for an Excel add-in. How do I do this? Is there a tutorial or site >>> someone can direct me to/ >> >> Drop by the Intel Visual Fortran forum at >> http://softwareforums.intel.com/ and we can steer you in the right >> direction. >> >> The fundamentals are that the routine has to have the STDCALL calling >> convention and you need to fully describe the DLL name, routine name and >> arguments in the Excel macro module. >> >> Steve Lionel > >
From: sbergero on 21 Mar 2006 08:31
richard symonds a écrit : > OK - As I look at more information - it may be that the xla needs to be > formed within Excel VBA code and then saves as an xla which is then > transportable as an add-in file. If this is true, then I guess I do need to > use the VBA and get the functions to work within Excel before moving to the > VBA. Can this be confirmed? > Yes. You need a VBA module to interface the DLL as describe by Steve Lionel. This module may be saved as XLA or XLS, depending on what you need. If you use XLA, it's highly recommended you store the XLA in one of the generic folder of Excel for add-ins (...Office/.../Library, ....Office/.../XLStart, ...Application data/.../XLStart, ...) AND IN THE SAME LOGICAL PLACE FOR ALL USERS / PCs. Without that, you will be unable to exchange the user's files. |