*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: th-cam.com/video/avdVI14AxzM/w-d-xo.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. ;)
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!
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 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 :(
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.
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
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!
*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: th-cam.com/video/avdVI14AxzM/w-d-xo.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. ;)
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
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!
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
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.
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
Loving the ChatGPT content!
Glad to hear that, Florian. Thanks for watching and your support - I appreciate it! 🙏
Do you have this for Mac computers?
Thanks for watching. No, I only have this for Windows - sorry! Cheers, Sven ✌️
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
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"
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
Go to macro security and click enable VBA and check the lower 2 boxes.
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.
How to get free API key for chatgpt4?
Thanks for watching. There is no free OpenAI key
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
Great
Thanks!
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
...👌🏽
👍🤩