turning excel spreadsheet into a software application

[webinvest]

Hi all,

Now I have no programing experience, I know very little about this, so please bear in mind.

I am trying to turn a particular excel spreadsheet I have made (the user inputs information and it creates a final answer(result)) and I want to be able to turn this simply into an application. So it is a seperate peice of software to excel.

Can anyone suggest how I can do this?

Thanks

[~s.o.s~]

Considering you have no programming expericence, any advice we give you would go for waste as you would have having no clue as to how to realize the idea. Learn a programming language of your choice. Maybe then you would be in a position to actually achieve something.

[webinvest]

what the hekk is wrong with u, another grumpybastardon the forums. Well maybe someone could point me in the direction of a simple program i could do it with, or a simple autorun type program.

Geez get a life

[~s.o.s~]

..and another l33t hax0r kid who thinks he can rule the world. Enjoy your ignorance. Oh and btw, avoid using explicit contents in your post, you might just get banned.

[jbennet]

Yes, please try to keep it clean. Bad news, but for your information, its not possible. You could write a program to automate excel, or use VBA to write a GUI for it, but the person running it would require excel on theier pc.

[webinvest]

Ok. Anyone know a simple program that can make a simple bit of software where the user inputs various things and it comes out with a final outcoe based on these variables?

[jbennet]

Visual Basic?

you could do something like (for example to work out a simple bill)

Dim HoursWorked as Integer
Dim PayPerHour as Integer
Dim CalloutFee as Integer
Dim Total as Integer
 
CalloutFee = InputBox("What was the callout fee")
 
PayPerHour  = InputBox("Enter Pay Per Hour")
 
HoursWorked = InputBox("Enter Hours Worked")
 
Total = (PayPerHour * HoursWorked) + CalloutFee
 
Msgbox("Total cost is: $ " & Total & " for the work")

[John A]

Believe it or not, Visual Basic has a learning curve. And it's made all the more evident when the programmer is impatient or gets angry at people who try to help him/her.

[webinvest]

know any good way of writing this into a simple form for a website, so it operates like an xcel formula. some sort of form generator?

[jbennet]

For a website?

You could use visual web developer and ASP.NET ?

[~s.o.s~]

know any good way of writing this into a simple form for a website, so it operates like an xcel formula. some sort of form generator?

You can always use HTML to create forms and Javascript for programming your logic. Its a matter of 100 lines of code (HTML + Script) depending on the complexity of the formula.

[DenisOxon]

Hi all, Now I have no programing experience, I know very little about this, so please bear in mind. I am trying to turn a particular excel spreadsheet I have made (the user inputs information and it creates a final answer(result)) and I want to be able to turn this simply into an application. So it is a seperate peice of software to excel. Can anyone suggest how I can do this? Thanks

The easiest way is to lock the cells with a password that you don't want the user to access, then they can enter data into the dataentry cells, but not change your code.

You can cover the hidden cells with colour, put instructions over etc.

Hope this helps

Denis