Hii ...for some reason it is not working for me...i have downloaded the excel file from the link and added my API key, it isn't showing any error but no output as well. Can you please help
Hi Hitch, First off thank you very much for this very interesting video. My question is, Do I need to obtain a "API Key" to make the VBA work," (To insert where indicated) If so, where do I get it. Thanks form, Ol'Canadian Guy
Hey so you can use this link and would need to create an account here openai.com/product I have an old video where in the first minute I show how to get the api key once you have an account opened m.th-cam.com/video/YblldhYf5vE/w-d-xo.html
Hi yes definitely possible would involve some extra work and depends largely where the data is. Some options would include (1) Web Query. Fetch data from some websites. Example: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;www.example.com", Destination:=Range("$A$1")) .Refresh End With (2) API requests. (3) SQLserver database connection (4) ODBC api connection There’s definitely many other ways and use cases combining web data + openai. One thing I thought of was like taking LinkedIn data and openai to make some excel sales bot. A lot of big sites also have APIs which could make it easier. Hope this helps
Hii ...for some reason it is not working for me...i have downloaded the excel file from the link and added my API key, it isn't showing any error but no output as well.
Can you please help
Hi Hitch, First off thank you very much for this very interesting video. My question is, Do I need to obtain a "API Key" to make the VBA work," (To insert where indicated) If so, where do I get it. Thanks form, Ol'Canadian Guy
Hey so you can use this link and would need to create an account here
openai.com/product
I have an old video where in the first minute I show how to get the api key once you have an account opened
m.th-cam.com/video/YblldhYf5vE/w-d-xo.html
Yes you will need to create an account and insert your own api key for everything to work
Theoretically, couldn't you add functionality to import data?
Hi yes definitely possible would involve some extra work and depends largely where the data is. Some options would include
(1) Web Query. Fetch data from some websites. Example:
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;www.example.com", Destination:=Range("$A$1"))
.Refresh
End With
(2) API requests.
(3) SQLserver database connection
(4) ODBC api connection
There’s definitely many other ways and use cases combining web data + openai. One thing I thought of was like taking LinkedIn data and openai to make some excel sales bot.
A lot of big sites also have APIs which could make it easier.
Hope this helps