You could create a library in Excel (aka addin), this would give you all of
the functions that you want, and wouldn't require you to learn/use a
different environment. I don't believe you can program the PIA's for office
using VB Express which means you would have to spend the money for Visual
Studio Standard. Either way, you would have to deploy your solution to all
of the desktops that use it. So you don't really 'gain' anything using
Visual Studio. If you do go the Visual Studio route I would recommend Visual
Basic, since it supports optional parameters, which will save a LOT of typing
for some functions. Just my two cents worth.
Good luck
Mark

"Mark Olsen" wrote:

Hi,
I am using VBA in excel to create a program that queries a database and
fills out excel spreadsheets. I have made a list of Classes that I use and
need to be able to use the same classes in several different projects.
Earlier I asked a question about how to create a "library" so I could have
all of the classes in one place. I got a great answer about creating a new
workbook containing the classes that I would reference. However, I still
dont get some of the more object oriented features of the new versions of
Visual Basic. I was wondering if I could use Visual Basic 2005 Express
Edition or the Full Visual Basic .NET to create a library that I could use
from VBA. Is this possible? Is it worth it? It seems that this would make
maintaining and distributing the code a lot easier. Can anyone give me any
input?