Python app built by converting visual basic macros

[IanR]

Hi

I am only just starting to investigate Python to see if it is a language that will do what I need it to do.

I currently have a quiz app built around a Microsoft Excel form using Visual Basic – VBA Macros.

I want to get the app working on the web. There is no way to do this with Excel, so it is going to have to be converted to a different language that will run on the web. Rather than a total rewrite, I would obviously prefer to use some form of conversion/translation to at least do some of the work of converting the vba code.

I believe there are vba to python conversion tools. So I assume they would do much of the work of converting the current visual basic macros. In principle, I would have thought that would reduce the work to then manually programming the connections to python forms and graphs, to replace the connections to Excel forms and graphs.

If this makes any sense, does anyone have any knowledge or experience as to whether these assumptions are correct?

Thanks

Ian.

[Larz60+]

see: http://www.hartmannsoftware.com/Blog/Art...-in-Python

[IanR]

Hi Larz

Thank you for taking the time to reply to my question

I am a little confused. I followed the link. It gave me the 10 most famous programs written in Python and a consulting/training company. It did not seem to have information on converting Excel macros and forms to Python.
Am I missing something?

Thanks again for your time

Ian

[Larz60+]

Google 'convert excel macros to python'

One result: http://pythonexcels.com/mapping-excel-vb...to-python/
and
discussion about: https://www.reddit.com/r/excel/comments/...to_python/

[IanR]

Hi Larz

Thank you for taking the time to reply

I apologise for taking so long to respond, but I have been away

Yes, I had already Googled conversion of VBA macros to Python. It was the fact that this appeared so easy that I asked the question on this forum. However, the information you identified (as all the google references I can find) simply convert a vba macro to a stand alone Python script. I cannot find any reference to taking an Excel workbook, which has forms with VBA macros, and converting the whole thing into a python app, working with forms. Many other people ask questions on Excel forums as to how to get an excel workbook with macros working on the web. The answer is always "It cannot be done because Microsoft does not support VBA macros on the web".

Given that translating the VBA macros is the hardest part of the job, I am amazed that there is not a way of using a conversion to Python to do the whole job of being able to get an Excel workbook with forms and vba macros working on the web.

Thanks again

[Larz60+]

Sorry, I haven't used VBA for many years, so perhaps shouldn't have responded at all.
Nevertheless, you should probably go to https://pypi.org/ and search for python packages by keyword as
this repository has at last count 140,034 packages.

Look at modification dates to see if it is actively maintained. Also check the python versions that it supports.
I have been programming since 1968, but during that time, my only use of VBA was for reporting support.