Skip to main content

Chat GPT in Excel



ChatGPT is an AI chatbot developed by OpenAI. It has been trained to generate human-like responses to any promt you send to it. Working on getting ChatGPT into Excel using VBA. Would be posting how to do that here. Stay Tuned!

Comments

Post a Comment

Popular posts from this blog

Bring ChatGPT to Excel using VBA

In this blogpost we will show how to bring ChatGPT into Excel and chat with the OpenAI's ChatGPT from the comfort of your excel sheet. To do this we can use the following code Sub GetChatGPTResponse() Dim apikey As String  apikey = "Your aPI Key" ''''''''''get you API key from openAI account and paste it here.  Dim prompttext As String prompttext = Home.Range("B9").Text   ''Change the cell reference for your question as per your needs  Dim modelname As String  modelname = "text-davinci-002"     Dim url As String url = "https://api.openai.com/v1/engines/" & modelname & "/completions"     Dim xmlhttp As Object Set xmlhttp = CreateObject("MSXML2.XMLHTTP")     Dim requestData As String requestData = "{""prompt"": """ & prompttext & """, ""max_tokens"":1000, ""temperature"...
Post a Comment
Read more