Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
distribute rows from one workbook to other workbooks | Excel Discussion (Misc queries) | |||
Distribute a secure Workbook | Excel Discussion (Misc queries) | |||
have each workbook open as stand alone? | Excel Discussion (Misc queries) | |||
Distribute Excel Workbook with licence? | Excel Programming | |||
VBA building stand alone application | Excel Programming |