This is brilliant! The GPT 3.5 results look way better vs. davinci when I tested the prompts in the playground. Is there a refreshed version that we can expect with gpt 3.5 turbo.
The Outlook macro is able to generate common responses to the emails you select but it can't tell you what you should do with each one unfortunately. It's not quite that clever!
We've released a new version that has updated code in it. This should remove the error message you're currently seeing. Pls download this from our website following the link above & let us know if you still have any issues.
To replace an incorrect key, you'll need to open your Registry Editor (Windows button > type "reg" to find this) and replace the value at Computer\HKEY_CURRENT_USER\SOFTWARE\VB and VBA Program Settings\ChatGPTOffice\Settings\API_KEY
Thank you very much for this useful information. I tried to download the files from the link, but the link was error. Is there anyway to download the file?
Awesome! Thanks very much! I have been using Excel since it was Lotus 123 (ha ha) back in the 80s. The progress this software has made over the years is truly amazing. This latest major upgrade certainly takes the cake and it’s going to be hard to find another innovation to match what AI brings to the table.
Are you able to use the gpt-3.5-turbo model instead of text-davinci-003 to save on the costs? Just changing the model to the gpt-3.5-turbo in the VBA code did not work.
I got lost at "Put it in your Personal workbook". Could you translate what exactly you mean by that for us who only download a Google Excell spreadsheet once in a decade to attempt to be smart like Jeff? Please prruty please.
Here you go support.microsoft.com/en-au/office/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790?WT.mc_id=M365-MVP-5002589
Hi I noticed a few people are getting the 429 error. Unfortunately you do have to add some credits for it to work. The API credits are separate to chatgpt e.g. even if you have chatgpt+ you need to add credits. Hope this helps
For all of the credits used in the examples in this video, how much would they cost? I’m trying to get a feel for how far the credits last when using these buttons
Not sure how many free credits you get from OpenAI but as an example, we did 115,000 API calls in a month and it cost just over USD2 ... so it's pretty cheap!
Thanks for the reply. I found out it was only the issue for Excel, the code works perfectly in Outlook and Word. So I deployed the add-in version in Excel and it works. However, the Outlook Macros disappeared the next day with all VBE buttons turned grey, I just can not add anything as a developer, though I've set "enable all macros" for Macro Security.@@AccessAnalytic
The VBA in each program is standalone aside from using the same OpenAI API key. As such, you can add just code and buttons to the VBA in each program. The ReadMe doc in the download provides more info about how to add your own custom prompts
HELP someone!! I followed the macro installation video "Excel + ChatGPT Integration: The Ultimate Problem-Solving Duo" from Coding Is Fun, but my only result I'm getting is "Request failed with status 429".
You'll need to add a credit card to your account as this indicates you've used up your free quota with OpenAI. We're using ChatGPT3.5 which only costs a tiny fraction of a cent per prompt however so you're unlikely to incur a large cost. This is also mentioned in the ReadMe.PDF
@@AccessAnalytic It is possible to get this error without going over you quota. I have accessed $0 of the $18 credit and I still receive this message. There is no other comments on this error in the ReadMe.PDF. Can you give some addition guidance?
hey wyn , your tutorials are awesome and helpful , im currently planning to build an app that can get voice input and show insights of the data , i hope you can help me with this , ive seen that you have already did it in this video - ua-cam.com/video/qvKroogiUQk/v-deo.html it would be great if i get any useful insights and code works done in this project , so i can create an app for myself
This is great functionality, but I've tried this using my existing (free OpenAI account API) and a newly created account (and API), but get the following... --------------------------- OpenAI Request Failed --------------------------- Request failed with status 429 ERROR MESSAGE: { "error": { "message": "You exceeded your current quota, please check your plan and billing details.", "type": "insufficient_quota", "param": null, "code": null } } --------------------------- OK ---------------------------
You'll need to add a credit card to your account as this indicates you've used up your free quota with OpenAI. We're using ChatGPT3.5 which only costs a tiny fraction of a cent per prompt however so you're unlikely to incur a large cost. This is also mentioned in the ReadMe.PDF
This means you'll need to add a credit card to your Open AI account. It's quite cheap however e.g. I did 115K prompts in a month and it cost me USD2.87
Thanks for the marvelous Codes, does this support GPT-4.0?
We recently updated it to use v3.5 but unfortunately the end point we connect to doesn’t support v4
Hi, very interesting. Deos this work with MacOS with office 365?
Not sure sorry, I’m guessing the toolbar won’t work, but the vba code might. Not sure where the API key would get stored.
This is brilliant! The GPT 3.5 results look way better vs. davinci when I tested the prompts in the playground. Is there a refreshed version that we can expect with gpt 3.5 turbo.
Thanks ... and yes! We're just waiting on OpenAI to enable v3.5 with the endpoint we've used in the VBA code. Hopefully not too long now!
Great. Thank you Sr. Please, it could read the e-mails and summarize all to the user decision takes action?
The Outlook macro is able to generate common responses to the emails you select but it can't tell you what you should do with each one unfortunately. It's not quite that clever!
brilliant work
Thanks Robin
The response I get with Outlook includes the version has been deprecated. Are you going to update the vba to the newest model?
Thanks. We'll release a new version very soon. Stay tuned!
We've released a new version that has updated code in it. This should remove the error message you're currently seeing. Pls download this from our website following the link above & let us know if you still have any issues.
Hi: I've tried downloading from the site (and signed up for the newsletter) but when clicking the button, nothing happens. Am I doing something wrong?
Likely a popup blocker. Hopefully you got the version via email
The video is brilliant. Thank you for sharing
Thank you too!
I put the wrong KPI key at 1st time, how I can replace the old key to a new key? Million thanks!
To replace an incorrect key, you'll need to open your Registry Editor (Windows button > type "reg" to find this) and replace the value at Computer\HKEY_CURRENT_USER\SOFTWARE\VB and VBA Program Settings\ChatGPTOffice\Settings\API_KEY
Thank you very much for this useful information. I tried to download the files from the link, but the link was error. Is there anyway to download the file?
Thanks for reporting it, we’ll get it fixed and let you know here.
Link should work now
where do you enter your API Key in the macro?
The first time you click one of the buttons it triggers you to enter the API key
Awesome! Thanks very much! I have been using Excel since it was Lotus 123 (ha ha) back in the 80s. The progress this software has made over the years is truly amazing. This latest major upgrade certainly takes the cake and it’s going to be hard to find another innovation to match what AI brings to the table.
Glad it helped! It's quite amazing hey! Thanks for your feedback :-)
Really impressive! This is great.
Thank you! I'm glad you like it! 🙂
Are you able to use the gpt-3.5-turbo model instead of text-davinci-003 to save on the costs? Just changing the model to the gpt-3.5-turbo in the VBA code did not work.
The text-davinci-003 uses the cheaper GPT model already. It isn't using v4 so each prompt submitted is only a small fraction of a cent.
How can we change the code to make it work with the newer gpt 4 version?@@AccessAnalytic
@kevincardenas24 - sorry the end point we connect to doesn’t support GPT4
Could you please re upload the link? I am not able to download anything from your website😅
It appears to be working at my end, please email info@accessanalytic.com.au with a link to this video. Thanks
I got lost at "Put it in your Personal workbook". Could you translate what exactly you mean by that for us who only download a Google Excell spreadsheet once in a decade to attempt to be smart like Jeff? Please prruty please.
Here you go support.microsoft.com/en-au/office/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790?WT.mc_id=M365-MVP-5002589
Hi, looks great. I cannot download the file
Hi, we’re fixing that, will let you know once it’s working
Link should work now
Great video thanks
Glad you enjoyed it
Hi I noticed a few people are getting the 429 error. Unfortunately you do have to add some credits for it to work. The API credits are separate to chatgpt e.g. even if you have chatgpt+ you need to add credits. Hope this helps
Yes, correct! Thanks for your post. This is also mentioned in the ReadMe.PDF doc
For all of the credits used in the examples in this video, how much would they cost? I’m trying to get a feel for how far the credits last when using these buttons
Not sure how many free credits you get from OpenAI but as an example, we did 115,000 API calls in a month and it cost just over USD2 ... so it's pretty cheap!
File download is broken
Link should work now. Thanks
It doesn't work for me when I am sure I've put the correct API key in, the Message Box jumps out with "request failed 404 ERROR MESSAGE"
Not sure sorry, maybe a network / firewall issue?
Thanks for the reply. I found out it was only the issue for Excel, the code works perfectly in Outlook and Word. So I deployed the add-in version in Excel and it works. However, the Outlook Macros disappeared the next day with all VBE buttons turned grey, I just can not add anything as a developer, though I've set "enable all macros" for Macro Security.@@AccessAnalytic
@yifanfeng195 there’s a word document that I think ( if I remember correctly ) has a section on enabling macros with “mark of the web”
Thank you, I deleted the Macro cache under %APPDATA%Microsoft Outlook, which solved my problem.@@AccessAnalytic
Hi Wyn, how would I add multiple buttons and run single code on excel/outlook/word? Am I interpreting it differently or probably incorrectly?
The VBA in each program is standalone aside from using the same OpenAI API key. As such, you can add just code and buttons to the VBA in each program. The ReadMe doc in the download provides more info about how to add your own custom prompts
HELP someone!!
I followed the macro installation video "Excel + ChatGPT Integration: The Ultimate Problem-Solving Duo" from Coding Is Fun, but my only result I'm getting is "Request failed with status 429".
You'll need to add a credit card to your account as this indicates you've used up your free quota with OpenAI. We're using ChatGPT3.5 which only costs a tiny fraction of a cent per prompt however so you're unlikely to incur a large cost. This is also mentioned in the ReadMe.PDF
@@AccessAnalytic It is possible to get this error without going over you quota. I have accessed $0 of the $18 credit and I still receive this message. There is no other comments on this error in the ReadMe.PDF. Can you give some addition guidance?
Have you entered a credit card? We haven't seen this come up for other reasons as yet
hey wyn , your tutorials are awesome and helpful , im currently planning to build an app that can get voice input and show insights of the data , i hope you can help me with this , ive seen that you have already did it in this video - ua-cam.com/video/qvKroogiUQk/v-deo.html
it would be great if i get any useful insights and code works done in this project , so i can create an app for myself
Thanks, I just used the built in functionality of power bi. No idea on the code behind it sorry.
This is great functionality, but I've tried this using my existing (free OpenAI account API) and a newly created account (and API), but get the following...
---------------------------
OpenAI Request Failed
---------------------------
Request failed with status 429
ERROR MESSAGE:
{
"error": {
"message": "You exceeded your current quota, please check your plan and billing details.",
"type": "insufficient_quota",
"param": null,
"code": null
}
}
---------------------------
OK
---------------------------
You'll need to add a credit card to your account as this indicates you've used up your free quota with OpenAI. We're using ChatGPT3.5 which only costs a tiny fraction of a cent per prompt however so you're unlikely to incur a large cost. This is also mentioned in the ReadMe.PDF
This means you'll need to add a credit card to your Open AI account. It's quite cheap however e.g. I did 115K prompts in a month and it cost me USD2.87