20191129-Use-Of-Excel-And-VBA-For-MIS-Development-Slides

By -

20191129-Use-Of-Excel-And-VBA-For-MIS-Development-Slides

GALLERY OF SLIDES


















Comments

Post a Comment

Popular posts from this blog

Software Developer and Entrepreneur Journey

By -
Image
We, at Vikram Shankar Mathur , are very serious about the work we do. Scan the QR code given to learn more about us. The most important thing that needs to be said is this "Our work begins, from where your troubles begin". The concept of #ReverseEngineering is known to practically all, from the community of #programmers and #charteredaccountant 's alike. But not too many truly understand and implement #objectorientedprogramming while delving deep into a problem that requires a solution, urgent or not. If only every programmer would break their program into re-usable objects, this world would really be totally sorted! Be that as it may be, I began my career as the key of a customised #erpsoftware in a pharmaceutical machinery manufacturing organisation, where we broke down the entire organisation's needs into individual units, represented by worksheets, like Cash Payment Voucher, Bank Receipt Voucher, Sales Invoice, Purchase Order, Goods Receipt Note, Material R...
Read more

How-Best-To-Use-Merlin-AI?

By -
Image
 How-Best-To-Use-Merlin-AI? ======================== This Post is AI Generated =========================== To effectively use Merlin in your daily work, consider these key areas: *   **Contextual Awareness**: Ensure Merlin has access to the necessary context for your tasks. *   **Task Automation**: Automate repetitive tasks to improve efficiency. *   **Integration**: Integrate Merlin with your existing tools for a seamless workflow. Here's a more detailed breakdown of how to implement these strategies: ### Understanding Merlin's Capabilities Merlin is designed to assist with various tasks, from answering questions to generating content. To leverage it effectively, you should first understand its capabilities and limitations. *   **Information Retrieval**: Merlin can quickly find and summarize information from various sources. *   **Content Generation**: It can help draft emails, create reports, and generate ideas. *   **Ta...
Read more

VBA_ GeneratePythonCode_2025.xlsm

By -
Image
VBA_Generate_PythonCode_2025.xlsm This is a sneak peek at my latest passion: combining VBA and the systematic Python Programming.  Ultimately, I intend to develop a userform that will allow you to type in Python Code, but will also debug it before writing it to a .PY file. Amazed?? It will be possible, I know, the only factor that is critical is the time factor. However, the userform has been created, as shown in the graphic : Now, it is the error checking of the code that remains. Just wait and watch!! CA Vikram S. Mathur 19-May-2025 | 20:15 Hours IST ======================= Latest Update ================= 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 ju...
Read more