![]() I’ve created forms for this but a lot of the most simple things require building a macro to accomplish a task (like clicking on one item in a form to open another form). My department interacts with a lot of other departments and all those departments have their own work orders, so I have a database where we generate our own work order number for projects and if needed, we can put in the other department’s work order. If another programming language can teach me to build something that can act like Access I’d be all for it, although it does seem silly to try to invest all that time and effort into creating something that already exists.įor reference, I use Access to track work orders and inventory. I have already started learning some Python and will continue with that regardless but I wasn’t sure if it’s worth investing time in VBA. Learn how to respond to the workbook, worksheets, and application event of Excel for automating macro execution. Understand how you can enhance, customize, and extend the Excel user interface by modifying the Excel environment. ![]() I use Excel and Access a lot at work but I’m starting to need to learn how to use macros and automation and I was looking into how to learn VBA, but so often it seems like the response is always “just learn X instead” (and usually X = Python). Gain practical fluency in applying Visual Basic for Applications to Microsoft Excel. I’m a bit late to this conversation, but I’m wondering, are there alternatives to the macros/automation in the MS office products? Will a language like Python be able to do that kind of automation? Or, taking it to another level, would I be able to create a full database type program in different programming language? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |