LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default How to distribute a workbook as a stand-alone application?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
distribute rows from one workbook to other workbooks JD Excel Discussion (Misc queries) 3 November 14th 07 02:21 PM
Distribute a secure Workbook scott56hannah Excel Discussion (Misc queries) 1 June 25th 07 02:09 PM
have each workbook open as stand alone? jinx_uk_98 Excel Discussion (Misc queries) 0 November 22nd 05 10:37 PM
Distribute Excel Workbook with licence? Mike MacSween Excel Programming 10 February 24th 04 03:01 PM
VBA building stand alone application Roland Excel Programming 1 November 14th 03 01:19 PM


All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"