vba

  • | |

    Automatically Open Excel and Send Report Using Batch and VBA

    Bydatapandasadmin

      We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do this. First this is a batch file to open our Excel report called “data report.xlsm”, assuming the report file is in the same folder as the batch file. You can schedule the time this batch file is…

  • |

    Assigning a Simple Button to a VBA Code – Excel Microsoft Visual Basic

    Bydatapandasadmin

    This is a simple guide to create and assign a “button” to your simple VBA code. Credit to WiseOwlTutorials. You can check him on Youtube Let’s create a simple VBA code in a module A simple code like this will do for our example

      Now let’s create an object Click on the Developer Ribbon…

  • The Basics – Visual Basics Macro Programming Start Up

    Bydatapandasadmin

    This is a quick and simple VBA code with some comments about the structure and how it the basic syntax works for beginners. Credit to WiseOwlTutorials, you can check him out Youtube.

      This is the simple result of the above code.