VBA code as stand-alone

[Lionel Fridjhon]

I have written a program in Excel VBA and need to to sell
and distribute this program to many users. Some may not
have Excel installed.
Is there any way that I can produce a stand-alone program
with a runtime version of Excel built in on a CD?
I realize that I would probably have to obtain a license
from MS to do this, if this is possible.

Lionel

 

[AxeldraX]

i think there you need VB for. it makes stand alone programs. you can'
do this in VB

 

[Bob Phillips]

If your code manipulates an Excel object, workbook, worksheet, etc, then the
client needs Excel. That is where MS makes its money, you are not charged
for distributing programs.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Don Guillett]

But, please don't distribute Excel with it.

 

[Howard Kaikow]

The recipient would still need to have Excel installed.

 

[Gord Dibben]

Check out Visual Baler. May be useful. Don't know of anyone with experience
in using it so have no recommendations.

http://the-ciba.com/vbaler/vbaler.html

Use your existing spreadsheet knowledge to create Windows software.
Create secure, stand-alone applications in a familiar spreadsheet environment.
Import existing spreadsheets via the WK* format.
Design a sophisticated user interface using simple macro commands.
Prevent users from viewing and changing proprietary formulas.
Create custom menus, toolbars, macro-active cells, dialog boxes, pick lists,
tabbed worksheets, etc.
Integrate a context-sensitive help system.

****Distribute applications without royalties or the need for a spreadsheet
****program.

Gord Dibben Excel MVP

 

[Don Guillett]

I once used baler extensively for compiling into stand alone programs OLD
123 v2.2
spreadsheets I created. Made a lot of money on this. It worked OK for the
time and place.

From what I can see from their "current" web site, they are not very current
with the modern world.
I would NOT recommend as a substitute for Excel as you would have to
re-write all to very basic stuff.

I think I still have mine around somewhere if you would like to buy it from
me at a greatly reduced price. Ask OFF list.