How do I create an Access/Excel add-in AI powered, to recommend/optimize vba code?

[amorosik]

I see that specific add-ins for Access already exist that allow you, , by leveraging the capabilities of ChatGpt or other similar systems, to both create code based on a text query and optimize/verify existing code
The question is: how are these tools built?
I mean, if you want to build a tool like this yourself, where do you start?

 

[GPGeorge]

This would be a good question for ChatGPT, would it not?

 

[amorosik]

It was to let you know how to do this thing
I already know how to do it

 

[amorosik]

Building a custom Access addin is not for the faint of heart. I would think Microsoft would integrate copilot into Access and all other Office tools via the help menu option, or a connector?

If it can be done, we just need to find the right way to do it
We're not any dumber than anyone else
(Or maybe we are? )

 

[amorosik]

Okay, now we're getting serious.
1- Learn how to make an add-in for Access
2- Learn how to send requests to ChatGpt and receive responses
3- Learn how to copy/paste add-in code into module/form/report code

Is there anything else I need to understand?

 

[The_Doc_Man]

I predict AI is going to eventually put all software developers and many other humans out of business when anyone can use AI to "Do It Yourself" instead of hiring or buying something from someone else. All you have to do is provide the materials and tell AI to build it.

I predict that it will not put ALL s/w developers out of business as long as people don't improve their ways of thinking. I learned a long time ago that artificial intelligence cannot cope with natural stupidity or with lack of specific education. Those two latter categories will mean that there will always be room for developers to act as the "middle man" (OK, "middle person") in the person/machine interface.

 

[LarryE]

Humans brought AI into this world, and humans can take it out.

 

[Josef P.]

You would have to test what ChatGPT & Co suggest when you ask them for an Access add-in that optimizes VBA code.
Would the answer be that a VBE add-in might be more useful?

 

[The_Doc_Man]

Taking notes from D.F. Jones's "Colossus" novel, if they have no power, they are dead. A computer's attention span is no longer than its electrical cord. I'm waiting for these AI sites to build up in areas and then start sucking power from the nearby generators. At which point, because the demand will be high and the supply will have a hard time catching up, the cost/price will go up. We are heading that direction in the AI center being built near Alexandria, Louisiana. There is considerable agitation among the voters now, even before the plant is built, that the cost of power will rise meteorically due to the heavy load that will be placed on the electric utilities. And based on past history, I can't say they are wrong.

 

[LarryE]

here's google ai's answer to that
View attachment 121976

Well of course google AI would answer like that. Who programmed google AI to say that?