I have a complex spreadsheet i am looking to market, however i dont want to
use Excel as the platform.

How would i go about creating an actual application from the spreadsheet
that can stand alone without the need for Excel?.

Is there a way to easily create an application from a complex sheet?

Can anyone help?

Thanks,

Roger

There is no way to directly translate what you have done directly into an
executable. The biggest problem is that you will loose the XL object model in
any kind of conversion. You will have to create your own version of
worksheets and workbooks. You could try to leverage XL by creating a
reference to it from the .net platform but that means that you can only put
your software onto systems that have XL installed. In any case it is a big
task requiring a good deal of progarmming knowledge.
--
HTH...

Jim Thomlinson


"Roger on Excel" wrote:

> I have a complex spreadsheet i am looking to market, however i dont want to
> use Excel as the platform.
>
> How would i go about creating an actual application from the spreadsheet
> that can stand alone without the need for Excel?.
>
> Is there a way to easily create an application from a complex sheet?
>
> Can anyone help?
>
> Thanks,
>
> Roger

On Jul 24, 5:10*pm, Roger on Excel
<RogeronEx...@discussions.microsoft.com> wrote:
> I have a complex spreadsheet i am looking to market, however i dont want to
> use Excel as the platform.
>
> How would i go about creating an actual application from the spreadsheet
> that can stand alone without the need for Excel?.
>
> Is there a way to easily create an application from a complex sheet?
>
> Can anyone help?
>
> Thanks,
>
> Roger

Welcome to the world of VBA programming -- it's a damn shame there
wasn't some "Build *.exe" button in VBA.

It's ambiguous as to what you mean by "dont want to use Excel as the
platform". Does that mean you don't want to use Excel at all, cells, sheets
etc. Or do you mean you do need to use Excel but don't want to use Excel's
VBA for some reason (lack code security perhaps).

Either way, although no longer officially supported you might look at VB6 as
the easiest learning curve from VBA. You can write an exe that might
automate Excel (its VBA object model is similarly exposed to VB6), not use
Excel at all, or make a dll or ComAddin that is called from Excel in turn to
do amazing things with sheets and cells.

Regards,
Peter T

"Roger on Excel" <(E-Mail Removed)> wrote in message
news:78187830-F7DA-4886-9AD0-(E-Mail Removed)...
> I have a complex spreadsheet i am looking to market, however i dont want
to
> use Excel as the platform.
>
> How would i go about creating an actual application from the spreadsheet
> that can stand alone without the need for Excel?.
>
> Is there a way to easily create an application from a complex sheet?
>
> Can anyone help?
>
> Thanks,
>
> Roger

Google "Excel compiler."