Hi,

I have been looking on the net for guidance as to how to progress an Excel spreadsheet program that I have developed. It's a program to track foods and symptoms which is intended to help people with diet related illnesses. There aren't any complex calculations but plenty of printouts and lots of areas to input daily data and produce graphs etc.. I orginally developed it all to help myself overcome my CFS and IBS and I'm now thinking about putting it together in such a way that others can easily benefit from it and hopefully make use of its facilities to help them find a way out of their health problems.

I'm trying to decide whether to develop it into a distributable application using VBA or to convert it into a stand alone .exe program. My concern now is that if I use VBA then people who may want to use it will have to have Excel ( an assumption on my part at the moment ) so that may restrict people who don't have/can't afford Office who may want to use it. Many CFS sufferers are out of work for a very long time.

An exe application gives it more flexibility ( plus cross platform capability ) but will certainly take me a lot more time to put together and no doubt will cost me a lot more too as I'm not at that level of programming and will need help. Also I can see that things may evolve and it will be easier to make mods in Excel/VBA so I am considering getting things together via this route at present in view of the flexibility and cost considerations.

I have looked on the net and seen third party applications which state that they will convert Excel workbooks in .asp / html/ java etc type web based applications but from what I've seen of the final product none of them looks too convincing in what they can do. I came across this site and thought that it was very helpful and I do like the idea of using VBA and maybe getting someone to help me put it together but then I felt that before making any decisions I would ask for opinions here about possible routes for getting something together which could easily be used by anyone with just basic computer skills.

I wondered if, having developed something in VBA, there was then a route in the future to translating the final product into a stand alone application without having to start from square one. I have done this in the distant past with a very expensive product which I used to convert a complex cashflow spreadsheet which I designed but I remember that the final product wasn't too good with graphs. This current spreadsheet of mine has a lot of graphs and also makes lots of use of things like comment boxes which Excel is good at and these I will need in the final form of the program.

I have seen distributed applications produced in VBA and some of them have looked very professional, well designed and easy to use and I very much like the idea of going this route but I need to do more research before making up my mind on this subject. From what I have seen I am inclined to go the VBA route, especially now that I have found this site and seen that I can get help and advice, but I appreciate that I need the input of experienced wisdom before jumping into a plan which means a lot of work and/or expense on my part.

My apologies if this topic has been covered elsewhere on the forum. Pointers to it would be appreciated if it has.

Any advice or pointers on this subject would be very much welcomed.
Kindest regards and very best wishes to you
Phillip