How to Use OpenAI GPT-3.5 in Excel Formulas with VBA (Updated)

In this video I make a VBA function using GPT-3.5-Turbo. Allowing you to use excel formulas the call openai GPT!
This is an update from an old video where I do the same thing. Since publishing that previous video the model and end point used has been deprecated. So in this new video I use the most up to date method.
So watch and you’ll be up to date on the latest practices of using OpenAi in excel!
You can find my VBA code on my GitHub: github.com/hit...
#openai #vbaexcel #gpt3 #exceltutorial

[@Aelh93]

thanks for the help ! really needed this for my automated websites specially now that chatgpt extension that I was using for Google sheets is no longer for free. New sub !

[@user-be2mj7ir6z]

Hey, great video. Very helpful.
I copied your script and executed the function on my Excel -2016. I executed the same function (=PERSONAL.XLSB!OpenAI.OpenAI("hi")) in several cells.
I am getting "Hello! How can I assist you today?" in a few cells and quite weirdly, just 'r' in majority of cells.
This is true for different prompts as well.
Why is this and where is this 'r' coming from? Can you please suggest how i can correct this?

[@yusareba]

for whatever reason, i'm just getting back the letter r. is it possible that you could put the excel file in the description? do you have to use a paid account?

[@Hitchon]

github.com/hitchon1/GPT3.5_VBA/blob/main/api_Key.xlsm
I added my file in above link also please note you do need to fill out openai billing info to use api keys they charge by token but you don’t need a subscription.
Above error sounds like you api key is missing, hopefully this helps :)

[@zesling]

I have fill billing details and i have also purchased openai subscription

[@user-be2mj7ir6z]

same error dude ... did you find any solution ?? Please let me know...

[@IanKayCey]

Yeah, I keep getting "r"

[@IanKayCey]

Nevermind, once i paid $5 dollars, it started working.
Man, this is so awesome. It;s like I can command the world from a tiny excel cell.
Thanks a bunch Hitch. You are the man.