Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.printing,microsoft.public.excel.programming
|
|||
|
|||
QUERY: API/SDK for Excel
Is there a MS Excel API/SDK? I just noticed a Excel plugin which was a dll
file. I am wondering whether it's possible for one to create his own plugins for Excel and how to go about it? Also, is it possible to link in Excel with another application, say a 3rd party program. So that Excel worksheets and cells correspond to values stored in a 3rd party program's database. |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.printing,microsoft.public.excel.programming
|
|||
|
|||
QUERY: API/SDK for Excel
Is there a MS Excel API/SDK? I just noticed a Excel plugin which was a dll
file. I am wondering whether it's possible for one to create his own plugins for Excel and how to go about it? I could possibly be way off base here, but I think that you need Microsoft Visual Studio Tools for Office to create something like you're talking about. Also, is it possible to link in Excel with another application, say a 3rd party program. So that Excel worksheets and cells correspond to values stored in a 3rd party program's database. If the Database is ODBC compatable (Many of them are) then it would certainly be possible. It would take a little bit of VBA, but not much. You would first have to setup the Database as an ODBC data source (odbcad32.exe). Actually, I don't even think you have to do that, you just have to create the database connection within your code. Lydon Bergin MCP, MOS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
QUERY: API/SDK for Excel | Excel Discussion (Misc queries) | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |