I'm asking chatGPT to write tests for my VBA code. Even when it doesn't make enough tests it creates a good sctructure from where I can build more cases
I have discovered ChatGTP only a week ago. It is amazing and scary at the same time. It has been very useful in finding errors in my SQL statements, Especially with JOINS to many tables. The code does not always work perfectly, but with a bit of digging, you get the answer sooner than you would have If you did not have ChatGTP. Where ChatGTP has been most useful to me, is in designing and finalizing my course on VBA in Excel for beginners. I really got stuck the last two months and just within a week I have made strides of progress. My aim is to teach programming to underprivileged children from the townships. Just the basics of programming. Most of them do not have access to computers or the internet. Thanks to ChatGTP I think I can bring my deadline a few months forward.
The great thing about this tool, is that you can interact with it. When your code does not work, you tell it the specific error and it will solve for that. This makes it such a great tool. The way I learned VBA was: figuring akut how to do sth in VBA, Posting my problems in VBA Forums and waiting for solutions from fellow VBA programmers. With ChatGPT this process is sped up making coding super productive.
I've found it to be quite helpful, especially with respect to getting it to add some basic documentation. It doesn't always work first time or is optimal but it certainly speeds up my workflow. I've also found telling it what I want to be corrected generally helps. It doesn't replace a human, at least not yet!
Thank you very much for the precious insights to the ChatGPT trend. I'm happy for those who have access ChatGPT from their countries. We hope we make it through the waiting list! From Cameroon 😊🙂🙂
An excellent, balanced review of ChatGPT. Great job. Wonder if Microsoft will make ChatGPT a part of Excel, creating an Excel version of Github Copilot.
At last. some sanity! I have seen the usual Excel suspects, who migrated from Excel to Power BI, all piling into ChatGPT and announcing that they've found the amazing Shangri La as they present piddling solutions to piddling problems. At least in this video we have someone who clearly knows what they are doing and they are testing ChatGPT with a keen and critical eye, thereby giving a more balanced view. I have tried ChatGPT a couple of times by asking it to write code in R for me. Two examples stand out: first one was about 75% correct and I corrected it, the second one was incomprehensible and I spent about 20 minutes trying to work it all out but abandoned it then as a lost cause. On the other hand, your experience shows that Chat GPT may be able to learn from its mistakes as you submitted a question multiple times: that is a worthwhile avenue to go down. Recently, I asked an Excel function creation program to create a specific LINEST() function for me and it failed quite badly. I asked the same question 4 or 5 days later and it got it right. So, there's hope! Of course, we have to support the quest for improvement and innovation so good luck to ChatGPT with its Microsoft $10 billion but for now, would you trust ChatGPT to do your work for you? I don't think so.
great tests illustrated here Paul! Thanks for that! When you know already a language that's a great tool that could spare you a lot of time rather than diving into the reference help of a function or module. although the best way to have the best of a language is to master it's reference guide.
for me ChatGPT gives very good start point, which doesn't work all the time, with the start code and rephrasing my question i get multiple code, which i mix and match to get my final code, ChatGPT has elimated my dependency on my junior staff, who would have taken days get me the same code. Apart from VBA, it has helped me immensely in improving my python skills, from a partime coder i can say I'm full time coder now.
Connecting the dots will still be a human task. Great answer for finding unique items in a list. We are in a situation of CAD systems in 80's. It created more jobs. Well the quality of designs went down the drain. I envision the quality of programming will go down rapidly as everybody will smear at experienced programmers. GePeTo, how I call it, will need to give even the uncomfortable answers like the limitations of solutions.
I asked Gptchat to calculate 2+5. It told me the result was 7. Then I wrote that my wife said it was 8 and that she is always right. Gptchat apologized and said the result was 8. Gptchat might not know everything about Maths or VBA, but knows all about women.
Although impressive the progress so far, the end result looks like an attempt at creating an easier "Google search", but for now with far worse results. I mean, having used StackOverflow and other sites for years, I can't recall finding answers so wrong as some of these (among those in a thread that we can tell easily that they're a serious attempt at answering). Your video shows well that we need good VBA skills to not get ourselves in trouble with some of ChatGPT's answers, which kind of defeats the whole purpose of using it. So as far as keeping our VBA jobs, I think we'll be safe for still a long time. At most, ChatGPT is giving us now code snippets. That's a very small part of coding and programming is much more than just coding. The AI does not know anything about the business process we're automating, the system analysis done, the architecture of the solution, let alone the application's, etc., etc. Nor will so soon, because of, e.g., data privacy and confidentiality issues it will raise.
@@Excelmacromastery You're welcome, I appreciate very much your videos and other resources. ChatGPT is already showing very impressive results in other areas but in programming it will be interesting to see all the developments still to come.
As complete beginner I discovered VBA in Excel. ChatGPT wrote me good code to place a market order on brokers platform via API. It only had few errors what I passed back to ChatGPT until got working code. The problem started with API response in JSON format to transform it in a table on a sheet. ChatGPT came up with complicated lengthy code and I could understand in general what it wants to do, but I could not sort out non-stop errors as I do not know VBA. Then watched @Excelmacromastery videos about dictionaries and collections and my task seems not impossible and I will try to create code useing examples and videos. Chat GPT couldn't even pull out from JSON response some of most important keys and values, as I actually did not need full data, just some main bits of it. In the process of interrogating ChaGPT I learnt few good things about VBA and how to use ChatGPT for some particular tasks and issues, but understood that I will still need to learn VBA and code myself.
Hi. Great video. Totally unrelated question. Is there any performance difference between office script and VBA? Office script is now bundled with my desktop excel
I found ChatGPT useful for ideas and code cleaning sometimes. However, with VBA it was able to help me after asking it multiple times for a certain solution maybe since its not that easy of direct of a language like python where ChatGPT in my opinion shines!!! 2 question ChatGPT was not able to answer me were: 1- What is faster to output from VBA an array to excel worksheet or range to excel worksheet? 2- If its a range how do i write a function for that taking into consideration that function is going to be an excel addin.
Thanks for this - I've been ignoring this up till now, because I didn't realise it could help with VBA. I use Excel every day (every spreadsheet under the sun, from home finances to Game Helper workbooks), and to be honest use VBA when I should probably be using sheet functions. (This is not to say that I don't use Google or SO every day - I have a memory like a paper trap) I may need to investigate this further - How do we get a key? Cheers
I do like ChatGPT's presentation style. Similar to you, I asked it for something I already had written "somewhere" before, but was being lazy and seeing how it would do. I asked for a macro to sort the sheets of a workbook, alphabetically. Its first effort was wrong, because it used a none existent function "array. Sort". So, I told it that it was wrong and why, and it responded by apologising, telling me I was right, and giving me a second attempt. This too did not work with a syntax error. So, at this point, I went and found the code I had previously written and in the same thread on ChatGPT, said "it still doesn't work, here is some code that does" and I pasted it in. What I liked and amused me was how it came back and again apologies and told me my code was right, and also why it was better than its attempts. It finished by praising the fact that I had used "application.Screenupdating", at the start and end to improve performance and stop screen flicker. So, it's not just the results that are impressive, it is its natural language capabilities and the way it responds that I find pretty awesome. Whilst I agree, rewording the question might get better results, it might also be useful (and amusing) to discuss why its efforts were wrong and see what it does :)
Just to add, I clicked the "thumbs up" emoji on its last response, and it recognised that it had got something wrong, and asked me "what should the response have been", so I pasted my code again, and am assuming that in some small way, this is helping it get better
I find that telling him what was wrong, helps. At least it will take it from there and you can ask him to carry on expending. So, my advice is start small. make something that works and ask him to complexify from there.
Stay one step ahead. You can use AI to write code faster and even set objectives faster. It is just a tool.....for now. Until you wake up in a slimy bath with electrodes attached all through your body and soon after you discover that you are Neo and you are the One to save the world from the machines. Well, good luck. I'll be dead by then
Currently using ChatGPT as a reference for code snippets. Some code provided is a bit odd, but if you take the time to do your vba handbook course you can edit the code to make it work.
Let me know your experience with ChatGPT in the comments below
I'm asking chatGPT to write tests for my VBA code. Even when it doesn't make enough tests it creates a good sctructure from where I can build more cases
I have discovered ChatGTP only a week ago. It is amazing and scary at the same time. It has been very useful in finding errors in my SQL statements, Especially with JOINS to many tables. The code does not always work perfectly, but with a bit of digging, you get the answer sooner than you would have If you did not have ChatGTP. Where ChatGTP has been most useful to me, is in designing and finalizing my course on VBA in Excel for beginners. I really got stuck the last two months and just within a week I have made strides of progress. My aim is to teach programming to underprivileged children from the townships. Just the basics of programming. Most of them do not have access to computers or the internet. Thanks to ChatGTP I think I can bring my deadline a few months forward.
Thanks for the feedback Mac.
The great thing about this tool, is that you can interact with it. When your code does not work, you tell it the specific error and it will solve for that.
This makes it such a great tool. The way I learned VBA was: figuring akut how to do sth in VBA, Posting my problems in VBA Forums and waiting for solutions from fellow VBA programmers. With ChatGPT this process is sped up making coding super productive.
Additionaly you can ask to improve the code!
Thanks for the feeback Max. Good to hear your experience.
I've found it to be quite helpful, especially with respect to getting it to add some basic documentation. It doesn't always work first time or is optimal but it certainly speeds up my workflow. I've also found telling it what I want to be corrected generally helps. It doesn't replace a human, at least not yet!
What's a good way to use it to write documentation? Are you telling it to write documentation based on the code you wrote?
Thank you very much for the precious insights to the ChatGPT trend.
I'm happy for those who have access ChatGPT from their countries. We hope we make it through the waiting list!
From Cameroon 😊🙂🙂
An excellent, balanced review of ChatGPT. Great job. Wonder if Microsoft will make ChatGPT a part of Excel, creating an Excel version of Github Copilot.
Thanks.
Excel already has AI in it but its nothing like this.
@@Lachesisms Excel now being updated with better AI
5:48 Creating sample data. Very impressive and useful.
At last. some sanity! I have seen the usual Excel suspects, who migrated from Excel to Power BI, all piling into ChatGPT and announcing that they've found the amazing Shangri La as they present piddling solutions to piddling problems. At least in this video we have someone who clearly knows what they are doing and they are testing ChatGPT with a keen and critical eye, thereby giving a more balanced view.
I have tried ChatGPT a couple of times by asking it to write code in R for me. Two examples stand out: first one was about 75% correct and I corrected it, the second one was incomprehensible and I spent about 20 minutes trying to work it all out but abandoned it then as a lost cause.
On the other hand, your experience shows that Chat GPT may be able to learn from its mistakes as you submitted a question multiple times: that is a worthwhile avenue to go down. Recently, I asked an Excel function creation program to create a specific LINEST() function for me and it failed quite badly. I asked the same question 4 or 5 days later and it got it right. So, there's hope!
Of course, we have to support the quest for improvement and innovation so good luck to ChatGPT with its Microsoft $10 billion but for now, would you trust ChatGPT to do your work for you? I don't think so.
Thanks for the feedback Duncan. It's definitely been overhyped in a lot of places.
great tests illustrated here Paul! Thanks for that! When you know already a language that's a great tool that could spare you a lot of time rather than diving into the reference help of a function or module. although the best way to have the best of a language is to master it's reference guide.
for me ChatGPT gives very good start point, which doesn't work all the time, with the start code and rephrasing my question i get multiple code, which i mix and match to get my final code, ChatGPT has elimated my dependency on my junior staff, who would have taken days get me the same code.
Apart from VBA, it has helped me immensely in improving my python skills, from a partime coder i can say I'm full time coder now.
Thanks for the feedback Suresh.
Connecting the dots will still be a human task. Great answer for finding unique items in a list. We are in a situation of CAD systems in 80's. It created more jobs. Well the quality of designs went down the drain. I envision the quality of programming will go down rapidly as everybody will smear at experienced programmers. GePeTo, how I call it, will need to give even the uncomfortable answers like the limitations of solutions.
I asked Gptchat to calculate 2+5. It told me the result was 7. Then I wrote that my wife said it was 8 and that she is always right. Gptchat apologized and said the result was 8. Gptchat might not know everything about Maths or VBA, but knows all about women.
:-)
My first "chatgpt" introduction was with button of record macros in vbe if far 2003rd year.🤗
Although impressive the progress so far, the end result looks like an attempt at creating an easier "Google search", but for now with far worse results.
I mean, having used StackOverflow and other sites for years, I can't recall finding answers so wrong as some of these (among those in a thread that we can tell easily that they're a serious attempt at answering).
Your video shows well that we need good VBA skills to not get ourselves in trouble with some of ChatGPT's answers, which kind of defeats the whole purpose of using it.
So as far as keeping our VBA jobs, I think we'll be safe for still a long time. At most, ChatGPT is giving us now code snippets. That's a very small part of coding and programming is much more than just coding. The AI does not know anything about the business process we're automating, the system analysis done, the architecture of the solution, let alone the application's, etc., etc. Nor will so soon, because of, e.g., data privacy and confidentiality issues it will raise.
Thanks for the feedback. You make some great points.
@@Excelmacromastery You're welcome, I appreciate very much your videos and other resources. ChatGPT is already showing very impressive results in other areas but in programming it will be interesting to see all the developments still to come.
Woah, it does include VBA too. I want to try to make random unique ID to notepad without fso.
Have you had a chance to test the newest update to see if it is has solves these issues?
As complete beginner I discovered VBA in Excel. ChatGPT wrote me good code to place a market order on brokers platform via API. It only had few errors what I passed back to ChatGPT until got working code. The problem started with API response in JSON format to transform it in a table on a sheet. ChatGPT came up with complicated lengthy code and I could understand in general what it wants to do, but I could not sort out non-stop errors as I do not know VBA. Then watched @Excelmacromastery videos about dictionaries and collections and my task seems not impossible and I will try to create code useing examples and videos. Chat GPT couldn't even pull out from JSON response some of most important keys and values, as I actually did not need full data, just some main bits of it. In the process of interrogating ChaGPT I learnt few good things about VBA and how to use ChatGPT for some particular tasks and issues, but understood that I will still need to learn VBA and code myself.
Hi. Great video. Totally unrelated question. Is there any performance difference between office script and VBA? Office script is now bundled with my desktop excel
Haven't run any tests yet but definitely an interesting topic for a video.
Great video!!
Excellent productivity tool.
I found ChatGPT useful for ideas and code cleaning sometimes. However, with VBA it was able to help me after asking it multiple times for a certain solution maybe since its not that easy of direct of a language like python where ChatGPT in my opinion shines!!!
2 question ChatGPT was not able to answer me were:
1- What is faster to output from VBA an array to excel worksheet or range to excel worksheet?
2- If its a range how do i write a function for that taking into consideration that function is going to be an excel addin.
Thanks for the feedback. I haven't used it with python yet.
Thanks for this - I've been ignoring this up till now, because I didn't realise it could help with VBA.
I use Excel every day (every spreadsheet under the sun, from home finances to Game Helper workbooks), and to be honest use VBA when I should probably be using sheet functions. (This is not to say that I don't use Google or SO every day - I have a memory like a paper trap)
I may need to investigate this further - How do we get a key?
Cheers
I do like ChatGPT's presentation style. Similar to you, I asked it for something I already had written "somewhere" before, but was being lazy and seeing how it would do. I asked for a macro to sort the sheets of a workbook, alphabetically. Its first effort was wrong, because it used a none existent function "array. Sort". So, I told it that it was wrong and why, and it responded by apologising, telling me I was right, and giving me a second attempt. This too did not work with a syntax error. So, at this point, I went and found the code I had previously written and in the same thread on ChatGPT, said "it still doesn't work, here is some code that does" and I pasted it in. What I liked and amused me was how it came back and again apologies and told me my code was right, and also why it was better than its attempts. It finished by praising the fact that I had used "application.Screenupdating", at the start and end to improve performance and stop screen flicker. So, it's not just the results that are impressive, it is its natural language capabilities and the way it responds that I find pretty awesome. Whilst I agree, rewording the question might get better results, it might also be useful (and amusing) to discuss why its efforts were wrong and see what it does :)
Just to add, I clicked the "thumbs up" emoji on its last response, and it recognised that it had got something wrong, and asked me "what should the response have been", so I pasted my code again, and am assuming that in some small way, this is helping it get better
Thanks for the feedback Mark. Very interesting to read your experience.
It does seem to confuse the array with arrays in other languages a lot.
thanks sir providing us the good information
Always welcome
Have you got access to and tried the new Bing Chat AI with VBA queries?
I find that telling him what was wrong, helps. At least it will take it from there and you can ask him to carry on expending.
So, my advice is start small. make something that works and ask him to complexify from there.
Is ChatGPT male, i thought it was female, heard it was on TV interview where voice was of a female 😀
A nice tool to know und use. The only thing is to find a proper application of it.
Justo lo que estaba esperando
Hope you liked it
is it not an issue if I get multiple answers for the same Question - at least least m code capabilities for power query seems limited
Could you make a video about using ChatCPT to convert 32 bit VBA to 64 bit VBA?
Now i am safe from my boss (with no vba knowledge) from replacing me with chatgpt 👍🏼
😄
Nikola: Your boss is not safe from you! 😂
@@houstonvanhoy7767 😆😆
Meh, I disagree with the statement that it missed a declaration. You made no mention that you were using option explicit.
Well there goes my career. I guess becoming a semi-truck driver wouldn't be so bad.
I think you'll be okay:-)
AutonomousDriverAI: Get out of my seat!
🤗
Stay one step ahead. You can use AI to write code faster and even set objectives faster. It is just a tool.....for now. Until you wake up in a slimy bath with electrodes attached all through your body and soon after you discover that you are Neo and you are the One to save the world from the machines. Well, good luck. I'll be dead by then
We need a complete Guide
" How to build Professional Excel Add-in "?
Ask ChatGTP
@@macwest1001 The complete Guide of Mr. Paul is better then ChatGPT.
It makes a lot of searching unnecessary if you want to get the syntax right
i use it a lot to teach the boys.
first vba question i asked chatgpt, already gave me a fake result. Well i was probably asking too much to begin with :D
Sometimes if you keep reword it you get a better answer.
Currently using ChatGPT as a reference for code snippets. Some code provided is a bit odd, but if you take the time to do your vba handbook course you can edit the code to make it work.
I find it hard not to see Jhon Carpenter's The Thing reflected in AI
Great movie
For me, chatgpt is a tool to get close to the solution, it's not the solution itself
As it is AI it continually learns so you can tell it that it made an error and what the error was. It then learns so will continue to improve
Real programmers don't need GPT. VB programmers obviously do.
Real programmers watch VB videos through:-)
This is unholy. Nobody should be using VBA anymore.
How else can you fully automate office applications?
@@Excelmacromastery c# or Javascript
please i would like to contact you by email