Ahhh, i see. Excellent. Since it is just an access database, it can be
automated.

For example, i often come across situations where i need to add a
function to a project that cannot refer to outside DLLs or addins.
It is possible to add a menuitem to the right-click menu of the VBE that
would extract the currently selected word, and retrieve the function in
the code librarian, pasting it into a new module or perhaps below the
currently selected line or procedure.

This would also be helpful when copying entire modules over to a new
project that has external dependencies. Just let Debug | Compile bring
your attention to the missing function, right click and automatically
get the function!

Also, this would allow me to populate the Code librarian in bulk. Say
that I believe a few of my modules have functions which are finalized,
and which have a function comment immediately below the declaration.
Then, I can search for each function in each of these modules and
programmatically add the description, function body, and author to the
code librarian - All I would need is to pick the category it belongs in
(could be a popup treeview form, prompting me for category).

Of course, I do not want to write this if it has already been done
before... if anyone has done anything like this, please let me know.

Also, if anyone had ever written an object model that wraps the
database, such that I could write code like the following, let me know.


Sub PleaseLetSomeoneHaveWrittenThis()
Dim Author As CAuthor, CodeEntry As CCodeEntry
Dim DB As CodeLibrianDB, strCode As String, strDesc As String

' ... Get code and desc.

Set Author = DB.Authors.Add("Public", "John")
Author.Initial = "Q"

Set CodeEntry = DB.CodeEntries.Add(strCode, strDesc, Author)

With CodeEntry.Keywords
.Add "My Keyword"
.Add "My Keyword2"
.Add "My Keyword3"

End With


End Sub


Harald Staff wrote:

Hi

Dunno if XP Developer is different, but see
http://groups-beta.google.com/group/...3?dmode=source
-it's nothing but an Access file. At least used to be.

HTH. Best wishes Harald

"R Avery" skrev i melding
...

I have recently found out about the Code Librarian, packaged in the
Office XP Developer cd... i have read online that it is supposed to be
an addin for the VBE, however when I installed everything from the CD, i
do not see any code librarian addin for the VBE. I do see a stand-alone
executable to view the code library, but i do not see any sort of addin
in the VBE for it.

Is there any additional configuration i need to do?

Also, is the code in the .clb file accessible through VB? Specifically,
there is some code that i KNOW i would like to access a lot and paste
directly into many different sheets using VB extensibility. For
example, using the Call Tree example in the Developer CD, one can
determine, under certain conditions, if there any function calls in a
module that are unresolved because the function does not exist in the
project. What could be done is lookup the missing function by name in
the code library and automatically dump it to another module in the
project called MissingFunctions...