*Here are the links* ⤵ VBA Code on GitHub: github.com/Sven-Bo/Integrate-GPT4-in-Excel-using-VBA MyToolBelt Excel add-in: pythonandvba.com/mytoolbelt Create your own Excel add-in: ruclips.net/video/avdVI14AxzM/видео.html
Thanks for watching. Good point. As I mentioned, this is more like a bare-bones VBA code without much error handling. If the return value from OpenAI, for example, starts with "=", then that also needs to be handled; otherwise, Excel will treat it as an Excel formula. All of that and additional error handling is already included in my Excel add-in (6:24 min). That said, the code is a bit more complex. ;)
Yes, MS Copilot will also be available in Excel 365. I believe it's beneficial to know the basics of Excel and then utilize AI tools, such as Copilot, to tackle more advanced tasks.
Loved your video, thank you!! Would you please suggest how we can change the code to output the returned completion to the next cell of the input cell, as opposed to the new sheet?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
So if you have a ChatgGPT Plus subscription, the API keys you can generate do not work unless you pay separately for the API through the billing as shown on his video. @codingIsFun great video, but missed this little detail :(
Thanks for watching. To fix the "Programmatic access to Visual Basic Project is not trusted" error, try the following: 1️⃣ Open Excel and go to File > Options 2️⃣ Select Trust Center > Trust Center Settings... 3️⃣ Choose Macro Settings and check Trust access to the VBA project object model 4️⃣ Hit OK and restart Excel 🖥️ That should fix the issue! Let me know if it works 👍 Cheers, Sven ✌️
@@CodingIsFun thanks earlier error is solved now comes the following error: "The OpenAI request has failed with status code:404 Error message: { Error { "the model gpt-4 doesn't exist or you do not have access to it," Type : invalid request error Param : null Code : model not found" }}
Hello, I appreciate what you have done. I can use ChatGPT in Excel, but only once if I try to generate text once again the error appears: That name is already taken. Try a different one. Error number 1004
Hey there, thanks for watching the video! I'm sorry I can't help you with your problem based on the information you provided. To give me a better idea of what's going on, it would be super helpful if you could write down which line of code is causing the error, and let me know if you modified the code from the tutorial. If you're having trouble figuring things out, another option is to join our Discord server at pyhtonandvba.com/discord. You can ask your question there and maybe someone in the community can help out. Thanks for understanding.
even with gpt 4 i am getting a 404 invalid_request_error type model_not_found code message the model gep-4 does not exist or you do not have access to it " any ideas as to what i did wrong? new to this stuff but loving the videos-- i subscribed ! thank you for your work!
Mine does not work. I get an error saying "An error occurred: Programmatic access to Visual Basic Project is not trusted. Error number: 1004. Line number: 40
*Here are the links* ⤵
VBA Code on GitHub: github.com/Sven-Bo/Integrate-GPT4-in-Excel-using-VBA
MyToolBelt Excel add-in: pythonandvba.com/mytoolbelt
Create your own Excel add-in: ruclips.net/video/avdVI14AxzM/видео.html
Thanks Sven, works well. One tip: if the prompt contains the double quotes character (Chr(34)) then it will throw an error
Thanks for watching. Good point. As I mentioned, this is more like a bare-bones VBA code without much error handling. If the return value from OpenAI, for example, starts with "=", then that also needs to be handled; otherwise, Excel will treat it as an Excel formula. All of that and additional error handling is already included in my Excel add-in (6:24 min). That said, the code is a bit more complex. ;)
Loving the ChatGPT content!
Glad to hear that, Florian. Thanks for watching and your support - I appreciate it! 🙏
Can copilot 365 and other ai tools can all works in ms Excel
Or is it still important to learn deeply ms Excel???
Yes, MS Copilot will also be available in Excel 365. I believe it's beneficial to know the basics of Excel and then utilize AI tools, such as Copilot, to tackle more advanced tasks.
So it is always better to learn ms Excel deeply all functions.
Having core knowledge of ms Excel, ai wil cherry on top
Loved your video, thank you!! Would you please suggest how we can change the code to output the returned completion to the next cell of the input cell, as opposed to the new sheet?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Awesome!!
Thanks! :)
Do you have this for Mac computers?
Thanks for watching. No, I only have this for Windows - sorry! Cheers, Sven ✌️
Is it possible to retrieve real-time data with this method? I have tried but it doesnt seems to work ?
No, that is not possible because of the GPT4 cut off day
So if you have a ChatgGPT Plus subscription, the API keys you can generate do not work unless you pay separately for the API through the billing as shown on his video. @codingIsFun great video, but missed this little detail :(
Thanks for watching. That is correct - the ChatGPT Plus subscription and OpenAI API usage are two different products.
Can you direct data from chatgbt into specific cells
Yep, you could adjust the VBA code. Happy coding! :)
i got following error "An error occurred: Programmatic access to visual Basic Project is not trusted
Error number: 1004
Line number: 40 "
what to do ?
Thanks for watching. To fix the "Programmatic access to Visual Basic Project is not trusted" error, try the following:
1️⃣ Open Excel and go to File > Options
2️⃣ Select Trust Center > Trust Center Settings...
3️⃣ Choose Macro Settings and check Trust access to the VBA project object model
4️⃣ Hit OK and restart Excel 🖥️
That should fix the issue! Let me know if it works 👍 Cheers, Sven ✌️
@@CodingIsFun thanks earlier error is solved now comes the following error:
"The OpenAI request has failed with status code:404
Error message:
{
Error { "the model gpt-4 doesn't exist or you do not have access to it,"
Type : invalid request error
Param : null
Code : model not found"
}}
@@Gameonslayer you simply just need to google that error message, and you will find a solution ;)
Is it possible to use the GPT4 turbo ?
Thanks for watching. Yes, that should work. You just need to change the model name, e.g. "gpt-4-turbo-preview"
Hello, I appreciate what you have done. I can use ChatGPT in Excel, but only once if I try to generate text once again the error appears: That name is already taken. Try a different one. Error number 1004
Hey there, thanks for watching the video! I'm sorry I can't help you with your problem based on the information you provided. To give me a better idea of what's going on, it would be super helpful if you could write down which line of code is causing the error, and let me know if you modified the code from the tutorial. If you're having trouble figuring things out, another option is to join our Discord server at pyhtonandvba.com/discord. You can ask your question there and maybe someone in the community can help out.
Thanks for understanding.
solved it by deleting the previous AI_OUTPUT sheet
can you explain more ? @@eddymeshack
even with gpt 4 i am getting a 404 invalid_request_error type model_not_found code message the model gep-4 does not exist or you do not have access to it " any ideas as to what i did wrong? new to this stuff but loving the videos-- i subscribed ! thank you for your work!
Hard to tell from a distance. Sorry, that I cannot help.
After doing full process then its showing error message comes : the chatgpt 4 does not exist or you do not hve access to it
Yepp, because it should be "gpt-4" and not "chatgpt 4" as shown in the video and in the provided code. Cheers, Sven
mine dossent work even tho i got chat gpt4
What exactly does not work?
Same here. The model gpt-4 does not exist or you do not have access comes
Mine has done the same :(
@@adampinos3466 are you using the free or pro (paid) version? GPT4 is only in the Pro version available
Paid same issue
Mine does not work. I get an error saying "An error occurred: Programmatic access to Visual Basic Project is not trusted. Error number: 1004. Line number: 40
Great
Thanks!
How to get free API key for chatgpt4?
Thanks for watching. There is no free OpenAI key
...👌🏽
👍🤩
Error message - The model Da Vinci - 003 has been deprecated
Interesting. I guess, you have modifed the VBA code, as in my template I have used gpt-3.5-turbo or gpt-4