I haven’t been afflicted with that change on my work computers.
I just checked Excel on my personal computer. First time I opened it, I didn’t have the Automate ribbon. Closed Excel, then reopened it to check on something in the household budget spreadsheet, and saw it.
Do you have any insight as to how VBA has been neutered? (I may decide to retire early if this means I’m going to have to redo a load of macros.)
I wonder if some bug related to those new functions somehow caused the #SPILL! errors I’ve gotten on the IPad in the past couple of days using existing simple text functions like FIND. Probably just user error tho.
My VBA macros are mainly calculations with loops that I choose to do that way, often one time, and fortunately are not work related (or paid work related; some are SOA exam volunteer work related). I will be very upset if I can’t use VBA any more for calculation routines.
I will be more explicit in what is not working – I was doing stuff like copying sheets between spreadsheets, and copying over values, manipulating objects, etc. Some things were only half-executing (such as pasting values only – it pasted items as formulas… to do it properly, I suppose I should have copied the values into an array and then put it into the new sheet. I was just being lazy.)
Certain aspects of Excel objects and methods in VBA aren’t behaving “properly” anymore with recent updates. I adjusted some of the code, but it only half-worked. Things were getting copied over, but as formulas, which was causing problems.
The Microsoft folks have always only half-assed VBA and never really liked it, so I see this as a step towards killing it.
Anyway, given the first macro I need is really just copy/pasting specific sheets over to a new notebook, but values only, that seems like a simple thing to try to Automate as a test. Let’s go!
And now I’m looking at it as an opportunity to rethink our processes entirely
and maybe teach other people other tools other than Excel.
The main reason I’ve been stuck in Excel is that I was the only person who knew non-Excel stuff. I need to use stuff other people can also do. I’ve been willing to help/teach but others have not had the incentives to branch out.