Welcome to Justanswer.com, my name is Dustin.I'm sorry to hear about the issue you are having, I will do my best to help you resolve it.
It sounds like when you say program you actually mean "macro"
Does your program require excel to run?
Im not sure how far you are into compiling the program.. You said it runs in excel.
Can it run without excel? Is it still conceptual, or do you have the program itself actually written?
Ok, So if you have a macro or set of macros built in excel, its possible to distribute them that way.
Of course the users would have to use excel to use your macros.
As far as distributing the program where its non excel dependent, before we discuss how to compile it into an exe or msi or installer package, youd have to have the program made first.
Im not trying to lead you in any direction but it sounds like you have a working package currently, and maybe discussing how to distribute the working product you already have would be a simpler solution then discussing how t o actually write a program that works outside of excel that you could compile for installation.
You havent given me enough information about the program in excel, or how you made it so that I could give any type of answer as to how to compile this into a standalone program.
How is this program written in excel.. VBA , Macros?
To compile this as a standalone program outside of excel, youd h ave to choose a programming language and write the program.. Unless you are using VBA or excel macros.. Then there are some possibilities that dont require full knowlegde of a programming language.
You arent answering my questions. I havent seen the "program" you have written.
I keep asking you, are you using Macros, or Visual basic within excel.. If you cant explain to me how you built the program, i cant advise what programming language to use, or if you would even need one..
You need to detail to me how you have this program built in excel, macros, vba script, a combination of those, or is this just spreadsheet formulas.. Or all three or more?
You built this in excel. You are the only one who can answer the above questions.
Excels current version and form are written in the programming Language C++
Since the programs and functions you mention run inside excel, using the same programming language would seem best. However, that means you would literally have to program the application from the ground up.. Starting from scratch.
Honestly, if excel is the foundation you are using and it sounds like your using just hyperlinks, it almost seems more efficient, easier and an easier adoption for your potential users if you distributed your work as a standalone workbook / template that can run inside excel.
When you say you want this as an installable program, maybe you are worried about your work being distributed without a paid "license" There are ways you can protect your current work if you were to distribute it. Such as, password ***** the workbook and other methods of version control.
but if you are intent on programming this from the ground up. C++ is what you want to use, since thats the language excel runs off of, and your "program" runs inside excel.
Seems like the path of least resistance.
I strive to provide great service, and greatly appreciate a 5 star rating clicked and submitted when you are satisfied.. I always answer follow up questions.Dustin S.Senior Technician and Network Switching Systems Operator / Maintainer.
C++ Can run on nearly any machine, you just need a compiler.. And then you are literally programming from the ground up.. Honestly, this space and forum would be impossible for myself or anyone else to teach you how to code in C++. Your looking at 3-6 months of constant focus and studying before your going to get to where you can create a semi complex program.
However, heres a place to get you started http://www.cprogramming.com/begin.html
It may be best for you to pay a programmer to create the program to your specifications, maybe not best. But this would take less time. If you would like some recommendations of where you can hire a programmer, let me know.