You're glad to have it when you're out in the woods though. Like you can cook a 5 course meal with just a swiss army knife, but it's probably not the best tool. It's a tool for analysts to solve a problem in the short term that complements the swiss army knife that is Excel. That's not how reality works, and because companies are lead by people and extant reality changes day to day, it never will imo.īut yea a program/process you need to develop that takes a lot of time and involves a whole team of devs is not something VBA should be used for. These arguments are hackneyed and rely on assumptions about the data stream's fidelity being 100% robust up and downstream, and business rules being static values. I don't think you understand how much of the money in the world is calculated and utilized with Excel as a medium, and VBA as the grease. That's why they never will, what is dead can never die. I'm not against Access, I've just been cautiously optimistic, but it's being received well.Īnd when they do millions will be forced to re-evaluate why they use it. We ended up hiring an Access developer on staff and he's making some good headway, in large part all starting from my excel/teams/powerBI models which now exist in MS SQL. We looked at all the out of the box CRM companies (Odoo, salesforce, a bespoke one for Laboratory management, which is what I do) and I just couldn't bring myself to believe it was long term sustainable, for a variety of reasons. I used power query and Power Bi to present to the management how we should be able to look at and track our data.īut power query is read-only so the need for a legitimate data base and CRM presented itself, and I'm not a DB developer, or a developer at all, just someone who writes macros as I need them and watches youtube tutorials in Python, VBA, etc. I structured them with the specific intention to be molded into a Database format for whenever we got to that stage. What I had done is sort of wrangled our various departments tracking systems into validated excel sheets in Teams which I could then power query and have dashboards, which did function. I didn't have much else in mind as a legitimate alternative. it's confusing at first but once you learn to think in that way it becomes immensely valuable and adaptable.
Django macro free fire windows#
vbs to replace file names and do stuff in windows explorer. I even write scripts in text pad and save them as.
When it comes to Office applications, VBA can do it all for you and do it in the self-contained environment of the Office suite that's why it will never die. How the process in question needs to work, how it very likely will need to change from month to month, and the potentially thousands of people and critical business functions that are affected by it. That's why dev teams are so big and have the agile, scrum, etc methodologies to compartmentalize a project.Īn analyst working on a small team using VBA like myself (sounds like you too), cares more about the why than the how and is necessarily seeing the big picture surrounding why this task even needs you to write code.
Django macro free fire software#
Software developers generally live in a very siloed world where they are given tasks and accomplish them without holistically seeing the big picture. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.
Django macro free fire code#
NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 kommentar(er)
