[Music]
hello everyone welcome to bentek and
today we'll be showing you how to remove
a password from Excel database for
example I have mine here and I want to
view my project
and I cannot access the password I have
tried I don't remember I want to break
it off
I don't have any software I don't have
an application for my PC but then I want
to remove it so what I'm going to do you
have to close this all come back to this
uh project or this file that you have in
here and the first thing first is you
have to make a copy of it right click
and paste it so now I've made my copy in
here now this copy we're going to is the
one we're going to manipulate with to
break up the password so we're going to
right click on it and rename so the
renaming we're going to rename this
xlsm extension in case you don't see
extension from uh your PC just go to
view and check on this file extensions
from here right click on it rename and
highlight that all
Andy you remove it and put the zip
once you put it as zip you can press
enter
kind of warning but you don't mind about
that just saying yes so this is going to
be a zipped file and now once you've
shipped it next thing we're going to do
is right click on it and extract it to a
specific folder that you want from me
I'm just going to extract to the same
folder the same folder name it should be
so I just click OK and right here I have
my copy which has already been extracted
so I'm going to open this file and you
hear you're going to get something like
four files out of these files we're
going to deal with the third one which
says Excel so this Excel you double
click on and open it I'm going to get
for the this pre file called the ba
project dot bin this is why we're going
to manipulate with so this one what
you're going to do here is right click
on it and open width open with a hex
editor in case you don't have a hex
editor just go to Google Search or
whatever search engine you're using and
type in their hex editor and whatever
website you're going to pick from it
actually works perfectly I already
downloaded it so I'm just going to open
my file
and I'm just going to open it like this
once you get this
um depends on the hex editor you
downloaded you're going to look for the
search button which is right up here for
mine then you click ok then from here
just go and search for
DBP uh dpb and you search for it
um once you get it it automatically
shows it highlighted in here in case
your computer does not show maybe it is
hidden somehow it maybe it's hiding like
this you're just going to click on this
one thing changes you just um
going to move it and be able to should
be able to show you
dpb now what we're going to do here is
just remove the B and change to any
letter you feel like me I'm going to put
it as X
and
so once I've changed as X
the next thing you're going to do is
just go and save it don't say server
just say save once you finish save close
everything
and close even this you can go back
using the back button or you can just
click on your folder so this is our copy
folder that we extracted you can open it
now we are back to these four files of
hours
highlight all of them and send them to
zip you can compress them
just compress it and say okay give me
the name you want let me say no password
whatever name you want it to be so I'm
going to put my no password and I say
okay once you're done with that the next
thing you're going to do is put back the
previous way it was which was
XL SM that is how it was before before
we made it a zip so now you're going to
put that and say okay
if you're done with that to bring some
warning again but just ignore and say
yes
now you can see your file is back the
way it was but now this one I'm going to
open it
maybe he's trying to recover to just say
yes don't mind about that
so it gives another warning like the
contains in validity at DPX but that
that is what we changed it doesn't
matter just go ahead and say yes
and some of these other things you can
you know them close it and you'll be
able to see your database so I have my
database here I can be able to use
anything that I want as it is however
you can't still access your code if in
case you wanted it
they're not accessible but once you
bring that it will pop up something just
ignore it and go ahead to tools
so when you're in tools come to VBA
project properties
and counter protection that is how
you're going to access your code because
it's locked for viewing so once you can
protection
check this and say okay once that is
done close now everything close even
this it will pop up that you need to
save so just save it don't forget to
save save
until redirect you to choose one
location which I'm going to say desktop
I'm going to just save my file in there
once that is done close everything and
this is my file with no password it is
on the desktop here so now I'm going to
open it
when you open like this there it is so
open this go to view check the VBA ah
you see my code my code is actually very
accessible now I can be able to edit
whatever I want to do in this so thank
you guys that's all if you like this
video please I share and also subscribe
I'll be grateful bye