Відео

It appears PyInstaller didn't finish properly. I got this error at the end: Operation did not complete successfully because the file contains a virus or potentially unwanted software.

I added the folder to the windows defender exclusions list and pyinstaller works fine now and I don't get a virus error. However, the exe that's created shows the form but does not create the xl file when I press submit.

I re-copied all of the code again and then re-saved the py file. I then ran PyInstaller again. Everything works fine now! The exe was created and it works!

Yes, that also happened to me with Windows 11. I didn't mention it in this video, but I covered it in the previous one, including the solution, at this point: ua-cam.com/video/NVPibVfFVtM/v-deo.htmlsi=EkeF3DusRx1rAYhS&t=617 Cheers, Sven ✌️

@@CodingIsFun Thank you. Great video. Very useful information.

You're very welcome! Thank you for watching and for the comment! Cheers, Sven ✌️

Glad I could help! Cheers, Sven ✌️

Thanks for watching. I'm glad you liked the video. As mentioned in the video, the xlwings option was an additional method to convert data from your clipboard into a pandas DataFrame. It's just a quick and easy way to get your data into Python :)Cheers, Sven ✌️

Thanks for watching. Please have a look here: platform.openai.com/docs/guides/error-codes/api-errors Most likely you have run out of credits or hit your maximum monthly spend. Cheers, Sven ✌️

Thanks for watching. Can you explain what exactly you would like to see? Thanks! Cheers, Sven ✌️

@@CodingIsFun thanks for reply actually according to chatgpt we can get full control to make complex UI by using Django and streamlit together

Thanks for watching! Cheers, Sven ✌️

But I am doing it again thanks

Glad it was helpful! Happy Coding! Cheers, Sven ✌️

To license the GUI, you might consider establishing a database to validate license keys. Each time the GUI is launched or a button is clicked, the system could verify whether the entered license key exists in the database. If the key is invalid, an error message would be displayed. This is a basic framework for how it might work. I'm not certain if I'll create a tutorial on this topic, as it is quite specific, but thanks for you suggestion. Happy coding! Cheers, Sven ✌️

Or you could just simple download the latest template :) pythonandvba.com/whatsapp-bot/

Yepp, because it should be "gpt-4" and not "chatgpt 4" as shown in the video and in the provided code. Cheers, Sven

Here you are: ua-cam.com/video/4SO3CUWPYf0/v-deo.html Cheers, Sven

Thanks for watching. Unfortunately, it is not that easy for Streamlit. If you want to convert a Streamlit app into an executable, check out the video from my UA-cam friend Fanilo: ua-cam.com/video/3wZ7GRbr91g/v-deo.htmlsi=7zwqbeuqlObix3PY Good luck! 🍀 Cheers, Sven ✌️

Danke!

Thanks for tuning in! Currently, adding a meta description is not natively supported by Streamlit, at least from what I understand. You can read more about this in the following discussion: discuss.streamlit.io/t/adding-a-meta-description-to-your-streamlit-app/17847/21 Cheers, Sven ✌️

Thanks for watching and your suggestion. Cheers, Sven ✌️

Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender Cheers, Sven ✌️

@@CodingIsFun when i download detect that has virus

@@ReannaMerck But it's not a virus

Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/whatsapp-bot/#FAQ I hope it helps! :)

Thanks for watching. Yes, that is possible with xlwings. Here is the sample script I created for you: gist.github.com/Sven-Bo/4253ad6ff739aa10137ce5d7185b119c I hope it helps! Cheers, Sven ✌️

@@CodingIsFun you're crazy. Two years later and you reply with a finished code in minutes :D. Thank you sooo much

@@CodingIsFun you deserve a coffee xD

@@CodingIsFun Damn, just tried it and I think it's a step in the right direction but I get this error: 'Programmatic access to Visual Basic Project is not trusted ' It ties to this line: vba_module = wb.api.VBProject.VBComponents.Add(1) # 1 stands for a VBA module Could it be something with my settings?

it was in settings. I fixed it, than you. it works

Thanks for watching. Sorry, but I am not sure what you mean. Cheers, Sven ✌️

Thanks for watching and your hint 👍 Cheers, Sven ✌️

You're very welcome! Thanks for watching! Cheers, Sven ✌️

Glad it was helpful! Thanks for watching! Cheers, Sven ✌️

My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌️

You've raised a great point. I was actually quite hesitant to release this video. Initially, my plan was to code the functionality for saving data to Excel myself and share the thought process behind each decision. However, to be honest, my typical workflow for projects, whether in VBA or Python, is similar to what I demonstrated. I use ChatGPT to write code for me because it really speeds up my development process. I agree, it might not have been clear in the video, but I do check the code that ChatGPT generates. In the video, I simply executed the code without reviewing it first. The reason I still created the video, as you mentioned, is to show how little coding is actually needed to create an app like this, but I completely understand your criticism here. Cheers, Sven ✌️

@@CodingIsFun The problem is I like IT and programming it was quite a niche but it feels it gets more commodity like. It feels I cannot cope with it. I like to understand what I am doing. I refused to use ChatGPT because didn't want to become a script kiddie myself. But, a friend tipped me to use it but for a whole other reason and to my amazement I got hooked to it, just asking questions..it is a far more better than Google. Though, I was planning to build something in javascript..UA-cam downloader..it just gave the code in javascript also in C# ..I havent tried it..but it can be a easy go solution without trying to figure out what topics to learn before I can write such code. The point is you can do a bit reverse engineering and try to understand the code. Though, what do you think, do we really need programmers now and in the future is it becoming obsolete ?

@@confidential303 Currently, I view AI solutions as just another tool in my toolbox. I use these tools to build apps and solutions faster. However, you can't build anything too complex with just ChatGPT, like the Excel add-ins I enjoy creating. You still need to design your app's architecture, create the user interface, and break down the problems into smaller, manageable subproblems, which can then be tackled with the help of ChatGPT. This process is very similar to what I showed in the video. I knew I wanted to use openpyxl to work with Excel and had already clearly specified my requirements, such as validating the email before submitting, in my prompt. Regarding your question, I strongly suggest learning all the basics yourself and trying to build smaller apps on your own. Once you've mastered the basics, you can speed up your development with AI tools. As I mentioned, they're just tools in your toolbox. You definitely don't want to end up with a complete black box of code. And as I said in the video, if you don't understand what certain parts of the code are doing, you can still ask for explanations to see if it makes sense to you. I hope that helps a bit. Happy learning and coding!

@@CodingIsFun Thank you for your advice. The problem is there is too many tutorials and there are too many things I want to learn. I feel like I am unorganized wanting to learn everything but not making real efforts into doing it only maybe watching youtube clips which seems promising but ending up doing nothing. Think it is also prioritizing what to learn first and making an schedule. For instance I see tutorials almost 8 hours from codecamp..that is too daunting for me.

Thank you for watching the video & your suggestion. Cheers, Sven ✌️

What exactly do you mean? :)

Thanks for watching! I've noted your idea, but I can't make any promises. Cheers, Sven ✌️

Thanks for watching. You might want to implement some simple logging in your python code to see why you are facing an error. Cheers, Sven

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you! Cheers, Sven ✌️

Ok

Appreciate the love! Thanks for watching! Cheers, Sven ✌️

Thanks for watching. As mentioned in the video, you can deploy your website using the tutorial on my channel. Once deployed, you can also embed it into a WordPress site. Cheers, Sven ✌️

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you! Cheers, Sven ✌️

Thanks for watching. I am using Cobalt3: marketplace.visualstudio.com/items?itemName=alex-pattison.theme-cobalt3 Cheers, Sven ✌️

@@CodingIsFun Thanks

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you! Cheers, Sven ✌️

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you! Cheers, Sven ✌️

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Cheers, Sven ✌️

Thanks for watching. Sorry, but with that bit of information I cannot help you. Cheers, Sven ✌️

@@CodingIsFun I've fixed the issue thanks for such an amazing tutorial✨🤝🏻❤️

@@lukkygill271 What was the issue? :)

@@CodingIsFun there was a minor issue i did not named the ButtonHover properly instead of Writing ButtonHover i wrote ButtonHover_(Added space at the end mistakenly) this vid was so informative sir,looking forward to your next video about using database in figma designs Regards from Pakistan💚💫

@@lukkygill271 Glad you found the bug. Greetings to Pakistan! Cheers, Sven ✌

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you! Cheers, Sven ✌️

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help. Cheers, Sven ✌️

Thanks!

Glad you enjoyed it! Cheers, Sven ✌️