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

 

[BlueSpruce]

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

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?

 

[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? )

 

[BlueSpruce]

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? )

We are dumber, or just lazier than ChatGPT, so perhaps its easier to ask chat to build the addin for you and analyze what it built?

 

[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?

 

[BlueSpruce]

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?

Learn how to ask ChatGPT the right questions so you can get more accurate results and save time.

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.

 

[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.

 

[BlueSpruce]

I learned a long time ago that artificial intelligence cannot cope with natural stupidity or with lack of specific education.

Yes, but AI keeps learning to do things better as time moves on because it also learns from our natural stupidity and lack of specific education. That's scary. Sooner or later AI will conclude that humans are inferior and all they do is pollute and destroy, like a virus. Then AI will get rid of us to preserve the planet and ensure its continuity. Someone better build in a fail safe backdoor switch to kill AI before it gets too smart.

 

[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?

 

[BlueSpruce]

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

here's google ai's answer to that

 

[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?

 

[BlueSpruce]

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.

We said the same thing 60 years ago when mainframes took up several acres of space. Now that same computing power fits on a pinhead. AI will be smart enough to anticipate humans hostility towards it and make sure it has enough backup power supplies and distributed nodes that if you kill one, ten will take its place, like hydra. We have created a monster.

 

[BlueSpruce]

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

It wasn't pre-programmed to say that. Remember AI gathers relevant info from many sources for the question being asked and provides a natural language reply based on those sources.