May-26-2018, 08:37 AM
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
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