but they are not expecting to make the editor as functional as that in Windows. Microsoft is making small improvements to the VB editor, and these improvements will be part of the monthly updates. Unfortunately the VBA Editor is not really ready to use: you cant insert new modules or UserForms, and while you can edit existing modules, you cant even view the UserForms. Mac Office 2016 does still support VBA, of course, and Microsoft has rebuilt the VBA Editor from scratch, which was drastically.
One of the interesting parts seems to be that Microsoft is building the VBA editor for Mac from scratch. I know there's a GUI for python, but then I assume I'd have to do python installations on client PCs and at this point excel and VBA seems easier.Microsoft Office 2016 was just released today with new additions to Office. I understand this can be done in python as well, but where would an end user come in? Is python better suited for analyst who are running a lot of ad hoc reports to be completed and delivered without the requester running anything themselves? The end users enter a range of dates, for example, and VBA macros manipulate the data, run pivots, charts, etc. It's outside of Excel, which seems inconvenient and I can't figure out where the end user comes in.Īs an example: In my job I create a lot of interactive dashboards, fed by data from Excel sheets and Access databases. I'm watching as many videos and reading as many articles as I can on Python but all of them seem to fail to tell me WHY I should use this. Like VBA, the syntax is pretty simple to pick up. I recently started playing with Python and I can see it has some great features. As a business analyst, I've been using VBA with Excel and Access for a while now and can usually accomplish my goals with these tools alone.
0 kommentar(er)
