Creating a working program / application from an Excel sheet

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

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.
 
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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create spreadsheet as stand-alone application 2
Problem transferring Excel macros to another language 1
opening an excel file from a website using vba 6
Excel ODBC driver created table/inserted data lost on application 1
Create Excel Lab test results 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to split an excel workbook in code and data 2
Moving from Excel to Visual Studio 3

Back
Top