GPT-4 Excel VBA Macro Hallucinations

Apr '23 • Coding

Hello all. I've been experimenting with creating a macro that would help me consolidate our ecom orders that would eventually be imported into our Xero for bookkeeping. The prompting seems to work just fine with the eventual sample data and tables that chatgpt shows are just what we want to achieve. However, when it comes to the actual vba code it seems to have missed out a lot of details which would result in the macro not working in reality. Is this the norm with coding whether it is vba or any other languages from GPT-4 especially?

4 comments