How do you expect to be able to create a stand-alone application that uses
Excel worksheets, and uploads to an Access database without using Office
products?

You can create a VB app that has forms, manages data, and even creates
reports, but if you want to use Excel worksheets or an Access database, you
need those products.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul Gallagher" (mod) wrote in message
...
I expect this is anything but trivial, but I would like to know what I
need
to learn in order to do it.

I have an Excel workbook that I use as a piece of data
importation/analysis/reporting software. It's comprised of six
worksheets,
has about 20,000 lines of VBA code and about 30 userforms, and uploads
report
data to Access. I'd like to be able to distribute it to colleagues, but
for
a number of reasons, I'd like to be able to distribute it as a
stand-alone
application that doesn't require the use of Microsoft Office products.

I get the impression that this is possible, perhaps using Visual
Studio.Net
and Visual Studio Tools for Office, but I'm completely unfamiliar with
these
products. I'm also by no means an expert or professional programmer,
obviously, having taught myself VBA as I went along developing this
workbook.
That said, I would like to learn, and would like to know exactly what it
is
that I need to know, if that makes any sense.

I've seen a few products that advertise the ability to transform your
Excel
books into applications, but I don't have much confidence that all the
funcitonality will be carried over, especially the ability to upload to a
database. I'd rather try to develop the application manually.

Thanks for any input at all!

Paul