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.
Large Language Models have been called Pathological Liars in a Box. They know what sounds good, but not what is true and what is false. Even in a closed environment like coding they fall down.
ReplyDeleteClaude (www.anthropic.com) is better for writing code. See also https://www.anthropic.com/claude-code
ReplyDelete