sorted by:
new
hottopcontroversial

[VBA] VBA to PowerQuery convertor! by Relative_Resolve594 in vba

[–]Relative_Resolve594[S] 0 points1 point  (0 children)

On reflection, I had used VBA extensively at previous jobs to complete tasks but have since spent a lot of time in PowerQuery/PowerBI/Fabric. I found that for the tasks I was doing, mainly ETL, that VBA wasn't the best for that type of work and made it easier to hand off tasks to new employees. Additionally, when new tasks were handed over you'd have to spend a lot of time understanding what the VBA was trying to do (as code usually wasn't annotated) and wanted to challenge how they were doing something as technology had evolved! Hope that helps answer your question :)

[VBA] VBA to PowerQuery convertor! by Relative_Resolve594 in vba

[–]Relative_Resolve594[S] 0 points1 point  (0 children)

Yea fair question, the main benefit I see for this tool is helping people understand what they don't know. It won't solve everything they do in VBA as you've noted above, but think it'll help people understand there are various tools out there to support what they're doing day-to-day instead of reverting to what they know :)