GPTchat for VBA

[1503-44]

Just tried it out

https://zzzcode.ai/answer-question?id=34e3fa99-de8a-4139-80eb-a42d13a69d80

--Einstein gave the same test to students every year. When asked why he would do something like that, "Because the answers had changed."

 

[IDS]

Thanks for the link.

It's certainly easy to use, and from a couple of fairly simple examples it seems to come up with reasonable code.

Reading data from Excel into a double array:

https://zzzcode.ai/answer-question?id=4f00467a-5c7e-4757-adc0-b7d97200a5a0

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[1503-44]

I've been resisting the call to AI. Ran into it by accident, so I thought I'd give it a test. I could have written it, but it would have taken a lot longer than 5 minutes.

--Einstein gave the same test to students every year. When asked why he would do something like that, "Because the answers had changed."

 

[IDS]

I've been resisting the call to AI. Ran into it by accident, so I thought I'd give it a test. I could have written it, but it would have taken a lot longer than 5 minutes.

Same here

I was fully expecting it to come up with something stupid, but at least for those I tried, it didn't.


Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[1503-44]

I gave it a harder test over at the chat site itself (chats not saved), like how to download the large data array from the OSM website. It knows quite a lot about writing the http request in the proper format, what data is contained in the array and it directed me to the appropriate API to use as well. It would have taken me a day or two to discover all that.

Got into some other nonprogramming subjects and there we had some trouble. I asked for a recipe to make Malaga Salad. GPT included black olives, red bell pepper and parslty. I suggested that it made a mistake, as they don't eat black olives in Andalucia and red bell peppers and parsley are rather strong flavours for cod, so seldom appear in the recipes. Maybe 1 in 10 to 15 recipes might mention those ingredients. GPT agreed that it made a mistake, apologised and revised the recipe. Caution is advised.

--Einstein gave the same test to students every year. When asked why he would do something like that, "Because the answers had changed."