Personal Library

[OldBirdman]

I have several functions I want to use in various projects. How do I maintain 1 copy in a standard location, but available to all projects?

[ChipR]

I believe you can keep a code module in a db, then import it to any new project.

[ChipR]

Or did you mean you want to avoid having to import?

[FishVal]

Hello, OldBirdman.

In the projects where those functions are desired to be available add a reference to that common mdb file.

Tools > References > [Browse ...] button and choose an appropriate mdb.

Regards,
Fish.

[OldBirdman]

I tried this, and the Browse... eventually wanted a *.olb;*.tlb;*.dll so didn't work. My functions might be

Public Function Max(varFirst as Variant, varSecond as Variant) as Variant
If varFirst > varSecond then Max = varFirst else Max = varSecond
End Function

This is a simplified example, so don't expand on the idea, I know about ParamArray, etc.
So I now have a project consisting of above function and similar ones. What next?

[FishVal]

:)

"*.olb;*.tlb;*.dll" are not the only file types available from "File types" dropdown list.

*.exe, *ocx, *.mdb, *.mde, *.mda, *.adp, *.ade and even *.* are available as well.

Regards,
Fish.

[OldBirdman]

Don't you ever sleep?
Thankx, I got it working. I somehow have never had the list of extensions not be correct, so I overlooked that I could choose others.

[NeoPa]

I've learned something new from this one :)

I had no idea this was possible.

[Dan2kx]

So if you make a DB full of functions and link in this way then you can just refer to them as norm!?

Is there any performance hit?

Dan

[OldBirdman]

I'm not concerned about performance, as these are primary to handle user input, and most users can't type over about 250 characters/minute. Any code to handle user interface is probably not optimum. If one of these were going to be called by a query with 100K+ rows, yes, then this would be an issue. But then again, I would probably be writing the function to specifically address the EXACT problem, not a general function.

[puppydogbuddy]

For anyone that is interested, here is a reference source:
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

[NeoPa]

Hey pDog, Any idea why I might not have the Code Librarian installed on my PC? I tried to follow the instructions (I have full Office 2003 Pro installed BTW).

[OldBirdman]

Thanks puppydogbuddy, but that link, and subsequent ones from there lost me. I'll quit with post #6 as it does what I need.
We link tables all the time, and if there were a cost/efficiency issue with linking, it should have come up there.

[puppydogbuddy]

@NeoPa
I believe the Code Librarian is included with the Office XP Developers Productivity ToolKit, which is a separate download. The problem is there so many downloads, I would have to check them all out. see this link:

http://beqiraj.com/office/2003/developer/index.asp