"Anthony Felder" wrote in message
...
Some time ago, there was a program called Baler which
could compile a Lotus spreadsheet into an EXE file. The
point was, you now didn't need Lotus to run the
spreadsheet and the formulas in the spreadsheet were
completely protected.
I would like to know if there is a program that can do
the same thing with an Excel spreadsheet. Baler is now
known as Visual Baler and you need to convert (save) an
Excel spreadsheet as a Lotus file and import it into
Visual Baler, but there are some problems, one of which
is that any VBA routines will not port over. My Excel
spreadsheet has a large number of VBA routines and I'd
prefer not to have to rewrite them over in Visual Baler.
The reason I am pursuing this tact is that I want to be
absolutely sure my spreadsheet (with VBA routines) can
not be compromised. I understand that I can protect my
spreadsheet, but I understand this option is not perfect.
Thank you for your time.
Anthony Felder
There are some tools available for developing spreadsheet
applications. Component One have a control for .net that
allows you to develop applications that can read and write
Excel files.
http://www.componentone.com/products...&ProductID=123
It wont support your VBA however, nor does it have
the cell functions Excel supports
You may find it easier to migrate your VBA to a com add-in
You'll need to rebuild the user forms and some controls
in VBA are subtly different their
VB equivalents (no multi
column list boxes in
VB for example) but its likely to
be easier than writing code to handle all the functions
http://msdn.microsoft.com/library/de.../comaddins.asp
Keith
Keith
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---