Skillwave Training @skillwave.training · May 5 A question came up in an AKA session that resonated with others: what do you do when #AIGenerated #VBA code seems to work – but is quietly making things worse? 🫣 Someone had been using an #AITool to help write a macro. Each time they closed #Excel, it prompted to save their Personal Macro Workbook.🧵
3 likes 2 replies
Replies
VBA might be the worst possible language for this. 'it runs without errors' and 'it does the right thing' are barely related in VBA, you only find out when someone actually audits the numbers months later
The AI's solution? Just save the workbook at the end of the macro so it doesn’t prompt to save changes! @excelguru.ca spotted the real issue immediately. ⚠️The macro was written using "This Workbook" instead of "Active Workbook" – which meant it was adding sheets in error every time it ran.