How to Integrate ChatGPT into Excel

Поделиться
HTML-код
  • Опубликовано: 29 окт 2024

Комментарии • 53

  • @CodingIsFun
    @CodingIsFun  Год назад +3

    *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

  • @SjorskePT
    @SjorskePT 8 месяцев назад

    Thanks Sven, works well. One tip: if the prompt contains the double quotes character (Chr(34)) then it will throw an error

    • @CodingIsFun
      @CodingIsFun  8 месяцев назад

      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. ;)

  • @florianroeseler2404
    @florianroeseler2404 Год назад

    Loving the ChatGPT content!

    • @CodingIsFun
      @CodingIsFun  Год назад

      Glad to hear that, Florian. Thanks for watching and your support - I appreciate it! 🙏

  • @TakashiToda
    @TakashiToda 9 месяцев назад

    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?

    • @CodingIsFun
      @CodingIsFun  9 месяцев назад

      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!

  • @goutamnayak5011
    @goutamnayak5011 Год назад +1

    Can copilot 365 and other ai tools can all works in ms Excel
    Or is it still important to learn deeply ms Excel???

    • @CodingIsFun
      @CodingIsFun  Год назад

      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.

    • @goutamnayak5011
      @goutamnayak5011 Год назад

      So it is always better to learn ms Excel deeply all functions.

    • @goutamnayak5011
      @goutamnayak5011 Год назад

      Having core knowledge of ms Excel, ai wil cherry on top

  • @CoNVertibleJay
    @CoNVertibleJay 8 месяцев назад

    Do you have this for Mac computers?

    • @CodingIsFun
      @CodingIsFun  8 месяцев назад

      Thanks for watching. No, I only have this for Windows - sorry! Cheers, Sven ✌️

  • @eddymeshack
    @eddymeshack 10 месяцев назад

    Is it possible to retrieve real-time data with this method? I have tried but it doesnt seems to work ?

    • @CodingIsFun
      @CodingIsFun  10 месяцев назад +1

      No, that is not possible because of the GPT4 cut off day

  • @smelx
    @smelx 11 месяцев назад +1

    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

    • @martijncabout
      @martijncabout 11 месяцев назад +2

      Go to macro security and click enable VBA and check the lower 2 boxes.

  • @amitrama1982
    @amitrama1982 4 месяца назад

    After doing full process then its showing error message comes : the chatgpt 4 does not exist or you do not hve access to it

    • @CodingIsFun
      @CodingIsFun  4 месяца назад

      Yepp, because it should be "gpt-4" and not "chatgpt 4" as shown in the video and in the provided code. Cheers, Sven

  • @apinos30
    @apinos30 11 месяцев назад

    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 :(

    • @CodingIsFun
      @CodingIsFun  11 месяцев назад

      Thanks for watching. That is correct - the ChatGPT Plus subscription and OpenAI API usage are two different products.

  • @dylanpugliese9284
    @dylanpugliese9284 10 месяцев назад

    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!

    • @CodingIsFun
      @CodingIsFun  10 месяцев назад

      Hard to tell from a distance. Sorry, that I cannot help.

  • @abracadabra962
    @abracadabra962 11 месяцев назад

    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

    • @CodingIsFun
      @CodingIsFun  11 месяцев назад +1

      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.

    • @eddymeshack
      @eddymeshack 10 месяцев назад +1

      solved it by deleting the previous AI_OUTPUT sheet

    • @Francesco_ars
      @Francesco_ars 9 месяцев назад

      can you explain more ? @@eddymeshack

  • @Gameonslayer
    @Gameonslayer 27 дней назад

    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 ?

    • @CodingIsFun
      @CodingIsFun  27 дней назад +1

      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 ✌️

    • @Gameonslayer
      @Gameonslayer 26 дней назад

      @@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"
      }}

    • @CodingIsFun
      @CodingIsFun  26 дней назад

      @@Gameonslayer you simply just need to google that error message, and you will find a solution ;)

  • @EdouardAndMeEdouardAndMe
    @EdouardAndMeEdouardAndMe 7 месяцев назад

    Is it possible to use the GPT4 turbo ?

    • @CodingIsFun
      @CodingIsFun  7 месяцев назад +1

      Thanks for watching. Yes, that should work. You just need to change the model name, e.g. "gpt-4-turbo-preview"

  • @haninawaya9967
    @haninawaya9967 Год назад

    Great

  • @ernsholt
    @ernsholt 11 месяцев назад

    mine dossent work even tho i got chat gpt4

    • @CodingIsFun
      @CodingIsFun  11 месяцев назад

      What exactly does not work?

    • @hemant0088
      @hemant0088 11 месяцев назад

      Same here. The model gpt-4 does not exist or you do not have access comes

    • @adampinos3466
      @adampinos3466 11 месяцев назад

      Mine has done the same :(

    • @CodingIsFun
      @CodingIsFun  11 месяцев назад

      @@adampinos3466 are you using the free or pro (paid) version? GPT4 is only in the Pro version available

    • @Ikilledthebanks
      @Ikilledthebanks 5 месяцев назад

      Paid same issue

  • @gunngunn6763
    @gunngunn6763 Год назад

    How to get free API key for chatgpt4?

    • @CodingIsFun
      @CodingIsFun  Год назад

      Thanks for watching. There is no free OpenAI key

  • @claytonsizwe
    @claytonsizwe Год назад

    ...👌🏽

  • @nikdandekar9863
    @nikdandekar9863 9 месяцев назад

    Error message - The model Da Vinci - 003 has been deprecated

    • @CodingIsFun
      @CodingIsFun  9 месяцев назад

      Interesting. I guess, you have modifed the VBA code, as in my template I have used gpt-3.5-turbo or gpt-4