converting an excel userform with VBA macros to a web application

Hi

I apologise if this question has been asked a hundred times before, but I have been unable to find the answer with a search on this forum

I have an Excel userform with macros that I want to convert to be used as a stand alone application that could ideally be used on the web, Android and IOS ( as well as Windows without the full version of Excel). The useform accesses various workbook sheets.

I appreciate it will not be a simple process, but would like to know all the various options that are available - and any advantages and disadvantages of the options

Someone has suggested to me that it could be converted into Python. Is that a possibility?

Thank you in advance for any information you can provide

Maybe take a look here https://www.xlwings.org/examples


Kind regards
Leo

Hi Leo

Thanks for that information

At the moment that seems to allow excel macros to be written in python. I am not sure that would allow it to run as a web application. I will try and investigate further

Thanks again for your time

Best regards

Ian

There isn't a simple answer to this, there's no automated way of doing this and the complexity and function of your workbook/macros dictates the difficult/level of involvement.

You'll probably need to recreate the functionality of your workbook from scratch using web technologies, this probably means a database for storing the data, a server side language for the grunt work/saving to the database and JavaScript for the user interaction.

This isn't something to be taken lightly, there will be a huge learning curve to each constituant part (database, server and client).

As to development stack, it depends, there isn't a right answer here. Do you want to get into web development, or do you just want to get this project into a web based form.

If the latter then I'd consider getting prices for someone to build it for you. If you really want to do it yourself, then I'd recommend the smallest learning curve, that would probably be ASP.Net webforms with a SQL Server database. As to the language, either C# or VB.Net - makes little difference, though you'll find more help and examples in C#. Webforms at least will ease the burden of learning loads of JavaScript and keeping within the Microsoft architecture will ease you into things through GUIs and mean that things will work well together.

If you want to learn web development, my answer would be different and I'm happy to go further, but it would be good to understand your goals.

Hi Kyle

Thank you for taking the time to reply

I certainly do not want to learn any new languages and am fully expecting to have to pay for the application to be converted into a form that will work on the web. So what I am looking for is the most effective way of converting it - so I know which expertise to search for. I would have thought many people would have wanted to do this, so I assumed there was a well tested way of doing it.

Thanks again

Ian

There isn't a simple answer to this, there's no automated way of doing this and the complexity and function of your workbook/macros dictates the difficult/level of involvement.

You'll probably need to recreate the functionality of your workbook from scratch using web technologies, this probably means a database for storing the data, a server side language for the grunt work/saving to the database and JavaScript for the user interaction.

This isn't something to be taken lightly, there will be a huge learning curve to each constituant part (database, server and client).

As to development stack, it depends, there isn't a right answer here. Do you want to get into web development, or do you just want to get this project into a web based form.

If the latter then I'd consider getting prices for someone to build it for you. If you really want to do it yourself, then I'd recommend the smallest learning curve, that would probably be ASP.Net webforms with a SQL Server database. As to the language, either C# or VB.Net - makes little difference, though you'll find more help and examples in C#. Webforms at least will ease the burden of learning loads of JavaScript and keeping within the Microsoft architecture will ease you into things through GUIs and mean that things will work well together.

If you want to learn web development, my answer would be different and I'm happy to go further, but it would be good to understand your goals.

Is this thread relevant

https://www.excelforum.com/excel-pro...ml#post4887097
?

Hi AB

Thanks for your time in replying

Yes that post is certainly relevant - and I share the same frustrations as Dal123. I have emailed easasoftware. In principle that would appear to solve the problem, but I am not optimistic that It will be a practical /cost effective solution. But I will update this thread with any information I get.

Thanks again

Ian

Here is the promised update
"While EASA would probably be perfect technically- At the low end it cost around $10K per year"

There are various ways of finding a contractor/company to do this for you. If you're on a real budget you could try something like freelancer, this would give you access to cheaper international markets and would probably be done on a fixed price. If you're looking for someone locally, day rates in the UK are dependant on location and technology stack, but typically you'd be looking at £350-£500 per day. How many days would be entirely dependant on what your workbook does and how complex it is, whether it's publicly accessible or you need user accounts, if you see this as a paid service payments can be quite involved etc.

I'd be happy to give you an idea of how much work would be involved if you could share your workbook.

Hi Kyle

Thanks for the offer, but this is a quiz for my daughter to use with the children she coaches. So budgets are limited.

Thanks

Ian

Hi Norie

Thank you for your time in replying

In very very simple terms, the user form is a multiple choice quiz that uses a spreadsheet of questions and four answers. There are four control buttons for a child player to select which is the correct answer. The macros are not that complicated, but it has taken a while to progressively build in the sophistication required. Basically, they keep score and time , and then record the results.

Is that enough detail?

Thanks

Ian

Hi !

A "macro", better a VBA code is just for some Office applications not for any Web applications.
As yet written, learn any Web language (or use a specific tool) or see with a Web designer you can afford …