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 | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |