This is my pet project, where you can see I have created a userform in which the Python Code can be typed, and on the click of a button, the “generated code.py” or whatever name you type into the second textbox will get saved to the same directory where the Excel File is located.
Two distinct advantages may be made visible by me:
(1) You can create multiple files from just one Excel file, because ultimately, I will be checking code validity before saving the file; and (2) The VBA coding will ensure that the Python Code confirms to the correct syntax, and allow you to make changes before saving the .PY file.
In any case, this is Version 01 of the Excel file. Cheers!!
I am an Indian Chartered Accountant residing in Ahmedabad, Gujarat, India. My Sole Proprietorship Firm is basically into the practice of Accounting, Auditing, Income-Tax Return Filing, Financial Consultancy, Statutory Audit, Tax Audit, Information Systems Audit and other related fields. After Qualifying as a Chartered Accountant on 08/08/1989, I was working in the Industry for six years. In May 1995, I began my practice as an Associate Chartered Accountant and upgraded to Fellow Chartered Accountant in 2002. In March’2006 I also became qualified as Diploma in Information Systems Audit (DISA), a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi. In March 2016 I got the additional certification of the Forensic Accounting and Fraud Prevention (FAFP), a course run by The Institute of Chartered Accountants of India, (ICAI), Delhi.
My sole proprietorship firm, Vikram S. Mathur & Co., Chartered Accountants, was initially registered with the Institute of Chartered Accountants of India in August 1990. In the year 2011, my proprietorship firm was merged with Kartik T. Vayeda & Co. Chartered Accountants when I joined them as Partner, and continue to be working in that capacity today.
I hope you enjoy your visit to my blog/website and would like to invite you to kindly post your valuable and insightful comments on your way out after visiting my blog/website. Thanks !!
Created on : 04/10/2024 Uploaded on : 04/10/2024 Modified on : 04/10/2024
