I have been trying to use ChatGPT to write me a VBA macro to extract every citation to a law in a swarm of declarations and rebuttal DOCX files under a particular directory on my PC. At first, it seemed like it might be useful. I am about to give up. It does not seem to have a VBA compiler. It often gives me code that fails the compile phase. Even when it does compile, it runs into errors caused by failure to handle error conditions involving corrupt files. It is very accommodating on revising this monstrous macro each time, but fails to learn from previous similar failures.
ChatGPT is no substitute for a skilled VBA programmer.
UPDATE: There are tasks it does well: for example, debugging a defective Makefile. Yes, I am embarrassed how much I have forgotten.