What Language Used to Create GUI to Access Excel workbook?

[fateshand]

Hey guys,

I'm putting together something for work. I'm not a programmer but I've spent a lot of time developing some fairly complex calculations in an excel workbook that I'd like to use an "example" for the backend or database.

I'm sure my programmers at work will use something other than excel when this is actually built. However, my GUI, which currently consists of a few user inputs and then a chart/calculations based on those inputs is all done within the excel doc at this time.

I'd like to throw together a more realistic GUI that can reference my excel workbook so it looks nicer and the concept becomes more clear for the programmers.

Are there any simple languages/software applications that I could use to create a simple GUI?

All I need in the GUI are about 3 input fields, a section to display a chart (pulled from the excel workbook) and a few other fields of data pulled from the workbook.

Any ideas?

 

[Jaafar Tribak]

Hey guys,

I'm putting together something for work. I'm not a programmer but I've spent a lot of time developing some fairly complex calculations in an excel workbook that I'd like to use an "example" for the backend or database.

I'm sure my programmers at work will use something other than excel when this is actually built. However, my GUI, which currently consists of a few user inputs and then a chart/calculations based on those inputs is all done within the excel doc at this time.

I'd like to throw together a more realistic GUI that can reference my excel workbook so it looks nicer and the concept becomes more clear for the programmers.

Are there any simple languages/software applications that I could use to create a simple GUI?

All I need in the GUI are about 3 input fields, a section to display a chart (pulled from the excel workbook) and a few other fields of data pulled from the workbook.

Any ideas?

I guess,you could use excel userforms to create such GUI.

Regards.

 

[fateshand]

Hmm, not sure what that is but I think I'll look into it. Thank you for the response.

I did a bit more research and I think I might try to build the application in Flash. I've got some experience with Flash and think this might be the most simple way to make the application visually appealing.

The only problem I am facing right now, if I chose Flash, is it seems that Flash and Excel can't communicate directly. From what I've read you have to take one more step and use a bridge between the two programs.

If that is the case I might have to not consider Flash. I need to keep this pretty simple and not terribly time consuming on the learning side of things.

 

[Jaafar Tribak]

Hmm, not sure what that is but I think I'll look into it. Thank you for the response.

I did a bit more research and I think I might try to build the application in Flash. I've got some experience with Flash and think this might be the most simple way to make the application visually appealing.

The only problem I am facing right now, if I chose Flash, is it seems that Flash and Excel can't communicate directly. From what I've read you have to take one more step and use a bridge between the two programs.

If that is the case I might have to not consider Flash. I need to keep this pretty simple and not terribly time consuming on the learning side of things.

I suggest you learn about how to implement UserForms in excel via VBA.If well designed they can be visually appealing and easy to use.

A nice place to start is on this forum.

Regards.