Тёмный

How to add an Auto-Updates feature for VBA Projects. Must Watch! 

VBA A2Z
Подписаться 51 тыс.
Просмотров 8 тыс.
50% 1

Friendly VBA tutorial on how to add an Auto-Updates feature for VBA Projects.
Useful Ready to use VBA Functions: vbaa2z.blogspot.com/2021/04/u...
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ru-vid.complaylists
Videos: ru-vid.comvideos
#VbaA2z

Наука

Опубликовано:

 

31 мар 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 77   
@susilsxzen-ff1zn
@susilsxzen-ff1zn Год назад
Your tutorials are the best. Thank you
@VBAA2Z
@VBAA2Z Год назад
You're very welcome!
@holieh5301
@holieh5301 3 года назад
Brilliant tutorial Pamai. This custom program will be super useful especially in updating excel or access plug-ins without having to reinstall with every update. Keep up good work, thanks
@VBAA2Z
@VBAA2Z 3 года назад
Absolutely! you're most welcome!
@noellecjaski5037
@noellecjaski5037 3 года назад
Thanks for your great contribution to the community! Excellent tutorials
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. thanks for watching
@nami_the_fish
@nami_the_fish 2 года назад
Omg, so useful. I've been trying to deal with most of these cases for the last 3 months. Sharing hugs
@Lvsis
@Lvsis Год назад
Thanks a lot Pamai! A whole office in Spain will stop receiving e-mails for software updates thanks to you. Very nice tricks while programming too, like the special functions template, dark background and "Immediate window", brilliant ;)
@VBAA2Z
@VBAA2Z Год назад
Great to hear!
@scottymars3289
@scottymars3289 3 года назад
Indeed you've made VBA great again :) Awesome contents! keep going . . .
@VBAA2Z
@VBAA2Z 3 года назад
Thanks a lot! for your appreciation and support
@arikurita401
@arikurita401 3 года назад
Surprising and interesting as always. fabulous one, thank you!
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. Glad you enjoyed it
@melivo853
@melivo853 3 года назад
Absolutely fantastic. Big thank you!
@VBAA2Z
@VBAA2Z 3 года назад
Glad you enjoyed it! thanks for watching.
@TH3LMITA
@TH3LMITA 3 года назад
Excellent Contribution! thanks for share all your knowledge
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome thanks for watching
@GiselleBrat
@GiselleBrat Год назад
Again awesome contents. Big thanks Sir.
@VBAA2Z
@VBAA2Z Год назад
Glad you like them!
@scottansir7708
@scottansir7708 3 года назад
Excellent work! Cheers!
@VBAA2Z
@VBAA2Z 3 года назад
Thank you! Cheers!
@hoseal8048
@hoseal8048 3 года назад
Fantastic one my friend, thank you!
@VBAA2Z
@VBAA2Z 3 года назад
Thanks for the visit
@joybyu1231
@joybyu1231 3 года назад
Thanks for introducing this awesome solution.
@VBAA2Z
@VBAA2Z 3 года назад
No problem! thanks for watching.
@SujithSurendran123
@SujithSurendran123 3 года назад
Your are simply genius.. This gonna help me a lot... Thanks a lot for sharing this knowledge.. RESPECT
@VBAA2Z
@VBAA2Z 3 года назад
My pleasure. Thanks for watching.
@mnewmai9413
@mnewmai9413 3 года назад
thank you sir. I love all your videos
@VBAA2Z
@VBAA2Z 3 года назад
Glad you like them!
@silunewmai9017
@silunewmai9017 3 года назад
Thanks for great content and useful functions. Keep up great work sir
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome, thanks for watching
@VipinThakur
@VipinThakur 3 года назад
Liked the video first and here is my comment now I am starting watching the video.
@VBAA2Z
@VBAA2Z 3 года назад
great! :) thanks for visiting
@mistahdee
@mistahdee 3 года назад
Amazing! just what i needed Thank you very much sir! PS: _I hit the like button 100x it just registered 1 like though._
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. Thanks for watching and for your support
@SaraPerzYT
@SaraPerzYT 3 года назад
Thank you so much
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome
@arianjico4441
@arianjico4441 3 года назад
Brilliant work! Thanks for sharing your knowledge and experience
@VBAA2Z
@VBAA2Z 3 года назад
So nice of you
@stevechow8892
@stevechow8892 3 года назад
you always make me surprise!it's so cool!
@VBAA2Z
@VBAA2Z 3 года назад
Thanks for watching
@penny2921
@penny2921 3 года назад
Practical, useful and to the point. Thank you
@VBAA2Z
@VBAA2Z 3 года назад
Glad it was helpful!
@jmstampe
@jmstampe 3 года назад
Dude this is amazing. I did this similar stuff a few years back but it was always hack and slash
@VBAA2Z
@VBAA2Z 3 года назад
ok cool, thanks for visiting!
@mashoqemuhammad5805
@mashoqemuhammad5805 2 года назад
keep up
@VBAA2Z
@VBAA2Z 2 года назад
thanks
@GoncaloFly
@GoncaloFly 3 года назад
Excellent tutorial as always. Thank you thank you
@VBAA2Z
@VBAA2Z 3 года назад
Glad you liked it!
@kiloonzjico7953
@kiloonzjico7953 3 года назад
Another interesting video. I’ll definitely try it out, thanks
@VBAA2Z
@VBAA2Z 3 года назад
Sure, please check it out and do let me know if you need any help.
@sensational4459
@sensational4459 3 года назад
Thanks for all ur videos. Can u provide any tutorial from where we learn web automation thru vba?
@VBAA2Z
@VBAA2Z 3 года назад
You're welcome. Check this playlist for VBA Web Automation. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2BF_Z8ogTis.html
@rohithkrishna9611
@rohithkrishna9611 3 года назад
Thank you so much for sharing your wonderful skills and knowledge Sir..
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome thank you for watching
@redhaakhund1271
@redhaakhund1271 3 года назад
🏆👍
@VBAA2Z
@VBAA2Z 3 года назад
Thanks!
@SixGraphics
@SixGraphics 2 года назад
Thanks much for your video, Can I use this code in access application??
@VBAA2Z
@VBAA2Z 2 года назад
Yes, you can implement / replicated it. COde will remain same for reading and writing.
@perymdiso1006
@perymdiso1006 3 года назад
Thank you for excellent tutorial. Do you have any good cheatsheets for bat?
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. Thanks for watching
@VBAA2Z
@VBAA2Z 3 года назад
Check this batch CheatSheet bit.ly/batCheatSheet
@atsevo
@atsevo 2 года назад
Is it possible to get update status from web-site? Because the goal is auto-update in on-line environment for me, local drive path is not useful. When I tried to modify the path ~~~~, it doesn't work correctly due to Bad name error. How can I improve it? Should I use other functions ?
@NancyCa198-a
@NancyCa198-a 3 года назад
Thanks for another relevant practical tut Pamai. Please make a video on how to create multi-level user security for UI and other objects in VBA.
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome and thanks for your suggestion.
@solimanalali8048
@solimanalali8048 3 года назад
Fantastic My question: Can I do something like that to alert me on certain dates Example: There are 15 days left for the expiry date of the ID (Msgbox)
@VBAA2Z
@VBAA2Z 3 года назад
Sure you can use Workbook open events or Class Object to handle this
@VBAA2Z
@VBAA2Z 3 года назад
Will try and demonstrate in upcoming videos.
@marcellokassa6975
@marcellokassa6975 3 года назад
Could you make a video about converting a vba project into .exe file in a very simple way?
@VBAA2Z
@VBAA2Z 3 года назад
Thanks for your suggestion. I will check it out.
@joshitoshi9835
@joshitoshi9835 Год назад
i couldnt understand what's the server u are talking about? u haven't used any server address, like that would be ideal if we use google drive folder as a server and if any updated version is available there than it should prompt for update, SECONDLY we must create a backup of the existing file before updating it in case we loose any data or something. And Most importantly like if i have updated the form only and have added or remove a cell than it should update that only, if it copy the newer file to old file than we will loose all data from old file. so in this case that method is not practical.
@VBAA2Z
@VBAA2Z Год назад
Thanks for the insights I'm sure it'd be helpful for our viewers. For demonstration I'm using local drive for both server and local however you can simply replace the path or can replicate using same approach with minor updates to code.
@luskfab
@luskfab 2 года назад
I hope this work with OneDrive / Sharepoint.
@VBAA2Z
@VBAA2Z 2 года назад
Should work ok with SharePoint lib
@luskfab
@luskfab 2 года назад
@@VBAA2Z can you make a video about this?
@yas.ibra.8742
@yas.ibra.8742 3 года назад
ReSpEkT
@VBAA2Z
@VBAA2Z 3 года назад
🙏
Далее
24 часа в самом маленьком отеле
21:19
ШОКОЛАДКА МИСТЕРА БИСТА
00:44
Просмотров 1,3 млн
5 VBA Hacks Everyone Should Know in 2021
11:20
Просмотров 90 тыс.
How to use ADO and VBA to Read from Worksheets
12:15
Просмотров 75 тыс.
Git MERGE vs REBASE: The Definitive Guide
9:39
Просмотров 90 тыс.
Don't throw exceptions in C#. Do this instead
18:13
Просмотров 252 тыс.
Which is the Fastest VBA Method For Reading Tables?
8:39
#engineering #diy #amazing #electronic #fyp
0:59
Просмотров 339 тыс.
Как работает экосистема Apple?
18:08