So I’m trying to work with ChatGPT 4 to develop some Excel VBAs, and I’m specifically asking it to help me go through the code that I have to make some updates (it is a LARGE code base). Problem is, I’ve lost three weeks on this effort because it consistently ignores what I ask it to do, in favor of second-guessing me and trying to “streamline” and “improve” the process…with the irony being that all its shortcuts keep causing the results to be unusable.
I’ve tried to tell it that, and it says it gets it and will do what I ask it…right before it goes right back to doing whatever it was doing that was producing unuseable results (as one example, it keeps wanting to use RegEx to analyze this code base to look for matches, but I’ve specifically told it–get this–84 times now that that won’t work, and it says it’s doing it manually but the result set clearly comes from RegEx).
How do I get it to actually do what I ask? It says I need to tell it that accuracy matters more than speed, but I’ve tried that too to no avail.