Discussion:
Write an addin for Access VBA-IDE
(too old to reply)
Alexander Mueller
2007-09-17 00:26:50 UTC
Permalink
Hi


i want to write my own little addin to MS-Access 2000 or higher
that exports modules of vba-projects to extern files, whenever a new
Project is loaded.

Any pointers on where to start?
Afaik i have to implement an interface in order to integrate into
ms-access, sadly forgot which one, think something with "Extensibility"
or such like. Any hints much appreciated!

MfG,
Alex
Alexander Mueller
2007-09-17 01:51:20 UTC
Permalink
Post by Alexander Mueller
i want to write my own little addin to MS-Access 2000 or higher
that exports modules of vba-projects to extern files, whenever a new
Project is loaded.
Any pointers on where to start?
Afaik i have to implement an interface in order to integrate into
ms-access, sadly forgot which one, think something with "Extensibility"
or such like. Any hints much appreciated!
Found it on my own:
The interface is called: IDTExtensibility2, typelib/server
is msaddndr.dll.

A how-to on how to implement it using VB.Net is available at MSDN,
applies to VB-6, too, with some modifications:

"How To Build an Office COM Add-in by Using Visual Basic .NET"
http://support.microsoft.com/?scid=kb;en-us;302896


MfG,
Alex

Loading...