Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a working program / application from an Excel sheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a working program / application from an Excel sheet
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a working program / application from an Excel sheet
On Jul 24, 5:10*pm, 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 Welcome to the world of VBA programming -- it's a damn shame there wasn't some "Build *.exe" button in VBA. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a working program / application from an Excel sheet
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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a working program / application from an Excel sheet
Google "Excel compiler."
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
working with excel and other program | Excel Discussion (Misc queries) | |||
display correct toolbar icon on starting excel application program | Excel Programming | |||
excel application does not shut down after program exit | Excel Programming | |||
Creating a tournament program in Excel 2003 | Excel Programming | |||
get the program id of an excel application from the task manager | Excel Programming |