How to remove password from excel? You can try PassFab for Excel (bit.ly/3x30okK), Remove password from excel instantly, without damaging original data, 100% success rate! PassFab also has big discount, promotion link: bit.ly/3wY4D11, PassFab Screen Recorder only 5$.
Sir, sorry if this is out of context of the video, I wanna ask if all of this knowledge of excel vba you share to us can be use to make professional powerpoint addons? I really want to make a powerpoint addons that suit my needs with excellent level of quality. There are many excellent powerpoint addons like "Brightslide", "PowerUser", "Powerpoint Labs", "ToolsToo" etc. And I wanna learn how to make those, especially "Brightslide" addons with sleek UI/UX. Sir, please answer me and guide me with some clue where to start? and can all of your tutorial videos about excel vba addons can 100% transfered to be used in powerpoint context? Thank you.
Hi, my vba coded file sometimes adds extra sheets in Microsoft excel objects which I am not able to remove. Remove sheet option is greyed out. a Also these sheets are not visible in excel. How can I remove these extra sheets from VBA window.
Excuse me, I want to ask, can it be in vba excel, insert attachments, sample excel, pdf, word files, which can be opened by just clicking on it... thank you
HI! I have been watching your video from past many years, I am stuck in a project where I need to add a button in outlook to trigger a UI. I know that is tricky but I am positive that you have a solution for this. can you please make a video on VSTO addin for Outlook? from scratch that would be helpful this is purely for the distribution purpose. so if you can extend it further on how to distribute an add in from VSTO to another PC would be awesome :)
I have a excel file .xls, when I try to open the file it is password protected how can I recover the password or open the file bypass password using cmd, visual studio code, or any other tool/utility
Hello! Could you please make a tutorial on how to create a PowerPoint add-in to lock/unlock objects? That feature is missing in PowerPoint. Thanks a lot!
Hi, if u dont mine please do videos on 1. Why / when/ what actually frontend/ backend devoloper need for software industry 2. What actually frontend developers do in realtime Scinorio Or when project assigned 3... Realtime frontend development tasks 4.. If project started what are the different tasks need to do--))by the frontend devoloper.. 5..Easy way to to crack any angular interviews with 3+ experience/10lack package ------) )) 6..Top 20 program's to cover entire angular syllabus.----)) 7...Top 10 angular concepts Please explain by taking one example/project 8...what type of skills (soft/technical)really need for industry 9... 4+ experience of frontend devoloper need to update what type of skills. ....
Is it possible to link the open excel file and Google Sheet, then export all the sheet names of the Google Sheet, and return the results to the open excel file. Or vice versa
Thanks you so much for sharing this... I learn advance Excel,array,dashboard,SQL,VBA. Could you please tell me what should I do next....thank you so much in advance
@@VBAA2Z thank you so much....I want to learn more....but I don't know what should I learn first Power BI or Python or Tableau or RPA or R programming. Coul you please suggest me
Hello, i have a question: "thisworkbook.save" code takes alot of time you know so i decided to use that code only in "Private Sub Workbook_BeforeClose(Cancel As Boolean)" subroutine. But the problem is when electric is off or somehow programme get a runtime error vba does not read the code. ( i dont want to get recovery offering because of users not familiar that) so what to do? Thanks!
Hi, My question is not related to this video but however I want to know what to do when there is an error saying "Automation error Catastrophic failure". I get this error whenever I reopen my file.
I already did but nothings help... before it was working fine and still there is no issue when I open the file first..but when I reopen it gives me this "Catastrophic error" and when I open VBA code it adds sheets which are not there and I can also see 2 thisworkbook "thisworkbook" and other one is "thisworkbook 1". One more this..if I am converting my file to xlsb ..it's working fine. But this is temporary solution.
Why not just change the extension to zip, open the sheet with notepad, and delete the entire line with the [Protect] tag. Then change the extension back to xls?
No it does not remove file open password, I think you've it for Excel Sheet password. Office 2016 employed 256-bit key AES password protection which also remains secure so there is no easy way to bypass.
How to bold part of a string in vba excel From excel sheet drop-down list,if we select how much big name it has to be bold in the letter. Example: If I select Rajith Tagore from Drop-down list Then the output should be This is to Certify that RAJITH Tagore Here Rajith Tagore should be in bold Please do the needful sir
try something like this. Example below will bold World from Hello World String ActiveCell.Value= "Hello World" With ActiveCell.Characters(Start:=7, Length:=5).Font .FontStyle = "Bold" End With
@@VBAA2Z if I want to bold Rajith Tagore in "Hello Rajith Tagore" Then I have to set the length manually in vba Please make it dynamic sir It has to adjust the length automatically for any text of any length in order to make it bold Plzz reply sir
Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy
How to remove password from excel?
You can try PassFab for Excel (bit.ly/3x30okK), Remove password from excel instantly, without damaging original data, 100% success rate!
PassFab also has big discount, promotion link: bit.ly/3wY4D11, PassFab Screen Recorder only 5$.
Sir, sorry if this is out of context of the video,
I wanna ask if all of this knowledge of excel vba you share to us can be use to make professional powerpoint addons?
I really want to make a powerpoint addons that suit my needs with excellent level of quality. There are many excellent powerpoint addons like "Brightslide", "PowerUser", "Powerpoint Labs", "ToolsToo" etc. And I wanna learn how to make those, especially "Brightslide" addons with sleek UI/UX.
Sir, please answer me and guide me with some clue where to start?
and can all of your tutorial videos about excel vba addons can 100% transfered to be used in powerpoint context?
Thank you.
yes you can.
Hi, my vba coded file sometimes adds extra sheets in Microsoft excel objects which I am not able to remove. Remove sheet option is greyed out. a
Also these sheets are not visible in excel. How can I remove these extra sheets from VBA window.
Most practical and best VBA Programming channel. Thanks for another useful informative video
Wow, thanks!
Excuse me, I want to ask, can it be in vba excel, insert attachments, sample excel, pdf, word files, which can be opened by just clicking on it... thank you
Yes sure, it is possible
Can you provide an example of the coding?
can you make a tutorial
HI! I have been watching your video from past many years, I am stuck in a project where I need to add a button in outlook to trigger a UI. I know that is tricky but I am positive that you have a solution for this. can you please make a video on VSTO addin for Outlook? from scratch that would be helpful
this is purely for the distribution purpose. so if you can extend it further on how to distribute an add in from VSTO to another PC would be awesome :)
Thanks for your suggestion. We'll try and make more VSTO videos
I used FabPass in past it never disappointed me. I'd definitely recommend especially for Excel password recovery
Glad to hear - Thanks for the feedback.
Thanks for sharing. Good to know there is some way to recover password.
Happy to help
Please come back with more videos!!! You are so amazing!!!!!!!!!!!!!
Thanks. Sure, more to come
I have a excel file .xls, when I try to open the file it is password protected how can I recover the password or open the file bypass password using cmd, visual studio code, or any other tool/utility
You can try passfab
Hello! Could you please make a tutorial on how to create a PowerPoint add-in to lock/unlock objects? That feature is missing in PowerPoint. Thanks a lot!
Hi Kitten, thanks for your suggestion. We'll talk discuss in upcoming videos
Hi, if u dont mine please do videos on
1. Why / when/ what actually frontend/ backend devoloper need for software industry
2. What actually frontend developers do in realtime Scinorio Or when project assigned
3... Realtime frontend development tasks
4.. If project started what are the different tasks need to do--))by the frontend devoloper..
5..Easy way to to crack any angular interviews with 3+ experience/10lack package ------) ))
6..Top 20 program's to cover entire angular syllabus.----))
7...Top 10 angular concepts
Please explain by taking one example/project
8...what type of skills (soft/technical)really need for industry
9... 4+ experience of frontend devoloper need to update what type of skills. ....
Thanks for your suggestions.
You’ve got amazing useful tutorials. Thanks for your hard work
I appreciate that!
Appreciate you sharing all these useful informative videos
My pleasure!
So nice of you
Is it possible to link the open excel file and Google Sheet, then export all the sheet names of the Google Sheet, and return the results to the open excel file. Or vice versa
yes you can use GoogleApisVBA Library
ruclips.net/video/XZ43G4rRqbI/видео.html
@@VBAA2Z Can you install more Vietnamese language in the subtitles?
will this work with word document too?
no this is for excel
Hello sir. How to transfer date from list view(✔that sellected) to other form in vba excel
Thanks you so much for sharing this... I learn advance Excel,array,dashboard,SQL,VBA. Could you please tell me what should I do next....thank you so much in advance
Start picking up projects so you are challenge with various project requirements and you'll automatically seek and learn more
@@VBAA2Z thank you so much....I want to learn more....but I don't know what should I learn first Power BI or Python or Tableau or RPA or R programming. Coul you please suggest me
@@priyankagupta951 I'd suggest go for
either Power BI or Tableau and Python.
@@priyankagupta951 Depends on your line of work. Can you share more detail or write to email in the video description?
@@VBAA2Z I am working as a MIS analyst. Apart from that I am part of VBA automation team
Looks promising. Trying trail version now 👍
Let me know how it goes
bought it (v.8.5.5) and played around a bit. So far, Custom Dictionary and Special Character Limitation aren't working as they should be.
Hi, please contact PassFab www.passfab.net/support/support.html
Hello, i have a question: "thisworkbook.save" code takes alot of time you know so i decided to use that code only in "Private Sub Workbook_BeforeClose(Cancel As Boolean)" subroutine. But the problem is when electric is off or somehow programme get a runtime error vba does not read the code. ( i dont want to get recovery offering because of users not familiar that) so what to do? Thanks!
Brilliant contents as always. Thanks Pamai
Much appreciated!
Hello bro 😗here ur new subscriber 💕
Thanks and welcome
Keep up the good work! thank you so much for sharing
Thanks for watching!
Wow amazing software. Thanks 👍
You're welcome!
Hi,
My question is not related to this video but however I want to know what to do when there is an error saying "Automation error Catastrophic failure". I get this error whenever I reopen my file.
Check this link stackoverflow.com/questions/31888880/automation-error-catastrophic-failure-excel-vba
I already did but nothings help... before it was working fine and still there is no issue when I open the file first..but when I reopen it gives me this "Catastrophic error" and when I open VBA code it adds sheets which are not there and I can also see 2 thisworkbook "thisworkbook" and other one is "thisworkbook 1".
One more this..if I am converting my file to xlsb ..it's working fine. But this is temporary solution.
How to enter password to show excel file(encrypt with password). Encrypt with password, call in vba.
not sure I understand
Looks fab. Thanks for sharing
Thanks Perym
Thank you, it helped me.
Glad it helped!
Thanks for another useful video
My pleasure
Keep up good work
Thanks, you too!
Looks amazing. Thank you Pamai
You are so welcome
your tutorials are the best but i never get the source code when i request plzzz help me
Please check and submit again here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
Awesome, thanks and keep it up
Thank you sir. Looks great!
Thank you too!
thanks!
Welcome!
Thanks for sharing
You're most welcome
Why not just change the extension to zip, open the sheet with notepad, and delete the entire line with the [Protect] tag. Then change the extension back to xls?
Hi Sergey, thanks for your comment.
This is for file open password not the excel sheet.
Tried each and every method, there is now way to crack the VBA password
please check here ruclips.net/video/787tdgvG8oQ/видео.html
Look like this made for me 😂 this happens at least twice a year for me. Thanks for sharing
You’re welcome 😊
thanks
Welcome
...long time no videos.... i hope you are well ❗👋😊
Nice 👍
Thanks ✌
wow you have a lot of videos! SUB!
Thanks and welcome
Thank you
most welcome
Simply opening in Google sheets will also remove the password
No it does not remove file open password, I think you've it for Excel Sheet password. Office 2016 employed 256-bit key AES password protection which also remains secure so there is no easy way to bypass.
@@VBAA2Z Ok think you are right
Now I know where to go if I lose my password 👍
Thanks for watching
How to recover the VBA password?
This app might help. please view
Dear .. are you alright.. from so many weeks your not coming online and not responding emails also
Please reply if everything okay 👌
Hi Abdul, all well - thanks for checking.
Coming with new series soon.
@@VBAA2Z thanks for your quick response and waiting for your new videos
You're most welcome!
Thanks VbaA2z
Any time
How to bold part of a string in vba excel
From excel sheet drop-down list,if we select how much big name it has to be bold in the letter.
Example: If I select Rajith Tagore from Drop-down list
Then the output should be
This is to Certify that RAJITH Tagore
Here Rajith Tagore should be in bold
Please do the needful sir
try something like this. Example below will bold World from Hello World String
ActiveCell.Value= "Hello World"
With ActiveCell.Characters(Start:=7, Length:=5).Font
.FontStyle = "Bold"
End With
@@VBAA2Z if I want to bold Rajith Tagore in "Hello Rajith Tagore"
Then I have to set the length manually in vba
Please make it dynamic sir
It has to adjust the length automatically for any text of any length in order to make it bold
Plzz reply sir
@@dynamic_duo157 you use functions such as LEN, MID, etc to dynamically construct that. You'll have to try it yourself.
Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy
Cheers, stay blessed.
👍💓
thanks!