Excel DLL Functions
Brett Stone
contained in each one. Does anyone have an idea where I could obtain this
information? Any help would be much appreciated. -Brett
Rob Bovey
Not sure exactly what you're asking, but here's a shot at an answer.
There aren't any Excel DLLs per se. All Excel-specific functionality is
wrapped up in Excel.exe. The functionality of Excel.exe is documented in the
Excel and VBA help files (for VB/VBA programmers) and the Excel 97 SDK (for
C programmers).
However, Excel.exe makes lots of calls out to various Windows system
DLLs. The best place to find documentation on these is Dan Appleman's VB
Programmer's Guide to the Win32 API or the Microsoft Platform SDK.
--
Rob Bovey, MCSE, MCSD
Application Professionals
http://www.appspro.com
* Please post all responses to this newsgroup *
* I delete all unsolicited e-mail messages *
Brett Stone <bre...@qcm.com> wrote in message
news:#22X9VmF$GA.248@cppssbbsa05...
Brett Stone
Excel application functions like product() geomean() ect.
There is a way in SQL to "install" Extended Stored Procedures basically this
means registering a .DLL and the function it contains with SQL Server. This
allows you to call these functions from SQL so they can be used in stored
procedures instead of having to go out to the Excel application. In order
to register the functions you need to know the .dll they are coming from and
the name of the function. So any information you have on where these
functions are called from would be appreciated.
Rob Bovey wrote in message ...
>Hi Brett,
>
> Not sure exactly what you're asking...
Rob Bovey
It sounds like all the stuff you're looking for is in Excel.exe itself.
If you're a C programmer, or you have one on staff, there's nothing
preventing you from writing a set of custom xp's that expose the Excel
functionality you want. You do this through Excel's C API. Details on this
kind of thing can be found in the Excel 97 SDK.
You can also get to all of Excel's built-in functions via automation.
Excel has an Application.WorksheetFunction object that exposes all of these
functions to automation clients. Note, that if you're using any functions
from the Excel Analysis Toolpak, things are going to be a bit more
complicated.
--
Rob Bovey, MCSE, MCSD
Application Professionals
http://www.appspro.com
* Please post all responses to this newsgroup *
* I delete all unsolicited e-mail messages *
Brett Stone <bre...@qcm.com> wrote in message
news:u2sHzOpF$GA.276@cppssbbsa04...