A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Programming
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

A simple way to crack VBA password in Excel file



 
 
Thread Tools Display Modes
  #11  
Old February 4th 07, 09:34 PM posted to microsoft.public.excel.programming
CAPTGNVR
external usenet poster
 
Posts: 115
Default A simple way to crack VBA password in Excel file

On Feb 4, 8:00 pm, wrote:
> Unbelivibale, but I found a very simple way that really works!
>
> Do the follwoing:
>
> 1. Create a new simple excel file.
> 2. In the VBA part, set a simple password (say - 1234).
> 3. Save the file and exit.
> 4. Open the file you just created with a simple editor.
> 5. Copy the lines starting with the following keys:
>
> CMG=....
> DPB=...
> GC=...
>
> 6. with a simple editor (again), open the excel file you don;t know
> the VBA password for,
> and paste the above copied lines from the dummy file.
> 7. save the excel file and exit.
> 8. Now, open the excel file you need to see the VBA code in. The
> password for the VBA code
> will simply be 1234 (as in the example I'm showing here).
>
> Simply works...
>
> Enjoy!
>
> Alen


AND I MISSED TO INFORM-- Still i went ahead and opened the excel file
in xvi32 and copied the whole thing and opned MY OLD FILE WHICH I
WANTED TO FIND THE VBA CODE. The rude shock was it GOT OVER WRITTEN
BY THIS SIMPLE EXCEL FILE. LUCKILY I DO HAVE A COPY OF THE
OVERWRITTEN FILE. So pls give me a bit more elaborate steps.

Ads
  #12  
Old February 5th 07, 06:54 AM posted to microsoft.public.excel.programming
Dobyns
external usenet poster
 
Posts: 1
Default A simple way to crack VBA password in Excel file

Does this work with Office 2007?



" wrote:

> Unbelivibale, but I found a very simple way that really works!
>
> Do the follwoing:
>
> 1. Create a new simple excel file.
> 2. In the VBA part, set a simple password (say - 1234).
> 3. Save the file and exit.
> 4. Open the file you just created with a simple editor.
> 5. Copy the lines starting with the following keys:
>
> CMG=....
> DPB=...
> GC=...
>
> 6. with a simple editor (again), open the excel file you don;t know
> the VBA password for,
> and paste the above copied lines from the dummy file.
> 7. save the excel file and exit.
> 8. Now, open the excel file you need to see the VBA code in. The
> password for the VBA code
> will simply be 1234 (as in the example I'm showing here).
>
> Simply works...
>
> Enjoy!
>
> Alen
>
>

  #13  
Old February 5th 07, 11:34 AM posted to microsoft.public.excel.programming
John Coleman
external usenet poster
 
Posts: 274
Default A simple way to crack VBA password in Excel file

On Feb 4, 11:55 am, "Tom Ogilvy" > wrote:
> You have to do this in a HEX editor.


OK, but why? Naively I would think that a string of characters (copied
into the clipboard in Notepad) = stream of bytes = stream of hex
values. How does the clipboard succeed in mangling these values? The
only thing I can think of is that maybe it inserts some padding bytes
here and there in a way that you have no control over. That, or maybe
the entire block is somehow misaligned.

Just curious

-John Coleman

>
> Hopefully you didn't need that file or made a copy of it (or it was just a
> play/test file). I think you can assume it is ruined.
>
> --
> Regards,
> Tom Ogilvy
>
> "Antonio" > wrote in message
>
> ...
>
>
>
> > Hi Alen,

>
> > I have followed the steps.

>
> > I have used Notepad as the editor.

>
> > I copy the lines from the dummy file on top of the same lines of the file
> > I
> > need the password for (target file).

>
> > Then I save this file with Notepad using Ctrl+S (not save as)

>
> > My problem is that when I try to open this file in Excel I get

>
> > "book2.xls" cannot be accessed. The file may be read only. Or you may be
> > trying to access a read only location. Or the server the document is
> > stored
> > on may not be responding.

>
> > What am I doing wrong?

>
> > Thanks,

>
> > Antonio

>
> > " wrote:

>
> >> Unbelivibale, but I found a very simple way that really works!

>
> >> Do the follwoing:

>
> >> 1. Create a new simple excel file.
> >> 2. In the VBA part, set a simple password (say - 1234).
> >> 3. Save the file and exit.
> >> 4. Open the file you just created with a simple editor.
> >> 5. Copy the lines starting with the following keys:

>
> >> CMG=....
> >> DPB=...
> >> GC=...

>
> >> 6. with a simple editor (again), open the excel file you don;t know
> >> the VBA password for,
> >> and paste the above copied lines from the dummy file.
> >> 7. save the excel file and exit.
> >> 8. Now, open the excel file you need to see the VBA code in. The
> >> password for the VBA code
> >> will simply be 1234 (as in the example I'm showing here).

>
> >> Simply works...

>
> >> Enjoy!

>
> >> Alen- Hide quoted text -

>
> - Show quoted text -



  #14  
Old February 5th 07, 06:39 PM posted to microsoft.public.excel.programming
srinivasan
external usenet poster
 
Posts: 30
Default A simple way to crack VBA password in Excel file

I also donot understand where to paste the copied data. to find on the same
cmg/dpb/gc and paste the lines? pl explaina little bit elaoborate?


  #15  
Old February 6th 07, 05:42 AM posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
 
Posts: 27,285
Default A simple way to crack VBA password in Excel file

A text editor like Notepad is expecting a textfile and therefore interprets
certain characters as control characters - such as vbLF, vbCR, EOF, new
page, tab and some of the other characters less than ASCII code 32.
Encountering the EOF indicator will cause the file to be terminated. This
usually happens well before the end of the file when reading in a binary
file. More than likely one reason why the OP could not find the target
strings and if he had found them and written them to another file, good
chance that file would be corrupted because the whole file wasn't read in
and subsequently saved. A hex editor doesn't try to interpret and act on
any characters. It give no meaning to the characters - just displays them
and allows you to change them and write the file back out.

Open an excel file in notepad. Change a recognizable character or even do
nothing. Save it over itself using saveas. See if you can open it in
Excel. In most cases, I would expect not - at least an not get the original
file. .

--
Regards,
Tom Ogilvy


"John Coleman" > wrote in message
oups.com...
> On Feb 4, 11:55 am, "Tom Ogilvy" > wrote:
>> You have to do this in a HEX editor.

>
> OK, but why? Naively I would think that a string of characters (copied
> into the clipboard in Notepad) = stream of bytes = stream of hex
> values. How does the clipboard succeed in mangling these values? The
> only thing I can think of is that maybe it inserts some padding bytes
> here and there in a way that you have no control over. That, or maybe
> the entire block is somehow misaligned.
>
> Just curious
>
> -John Coleman
>
>>
>> Hopefully you didn't need that file or made a copy of it (or it was just
>> a
>> play/test file). I think you can assume it is ruined.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>> "Antonio" > wrote in message
>>
>> ...
>>
>>
>>
>> > Hi Alen,

>>
>> > I have followed the steps.

>>
>> > I have used Notepad as the editor.

>>
>> > I copy the lines from the dummy file on top of the same lines of the
>> > file
>> > I
>> > need the password for (target file).

>>
>> > Then I save this file with Notepad using Ctrl+S (not save as)

>>
>> > My problem is that when I try to open this file in Excel I get

>>
>> > "book2.xls" cannot be accessed. The file may be read only. Or you may
>> > be
>> > trying to access a read only location. Or the server the document is
>> > stored
>> > on may not be responding.

>>
>> > What am I doing wrong?

>>
>> > Thanks,

>>
>> > Antonio

>>
>> > " wrote:

>>
>> >> Unbelivibale, but I found a very simple way that really works!

>>
>> >> Do the follwoing:

>>
>> >> 1. Create a new simple excel file.
>> >> 2. In the VBA part, set a simple password (say - 1234).
>> >> 3. Save the file and exit.
>> >> 4. Open the file you just created with a simple editor.
>> >> 5. Copy the lines starting with the following keys:

>>
>> >> CMG=....
>> >> DPB=...
>> >> GC=...

>>
>> >> 6. with a simple editor (again), open the excel file you don;t know
>> >> the VBA password for,
>> >> and paste the above copied lines from the dummy file.
>> >> 7. save the excel file and exit.
>> >> 8. Now, open the excel file you need to see the VBA code in. The
>> >> password for the VBA code
>> >> will simply be 1234 (as in the example I'm showing here).

>>
>> >> Simply works...

>>
>> >> Enjoy!

>>
>> >> Alen- Hide quoted text -

>>
>> - Show quoted text -

>
>



  #16  
Old March 6th 07, 07:01 AM posted to microsoft.public.excel.programming
abelard
external usenet poster
 
Posts: 2
Default crack vba password

i had tried with maxedit and when i open the file, the below error display

An error occured when initialising vba libraries

Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\user\Desktop\E2004_04.xls'
The following is a list of repairs:

Lost Visual Basic project.
Lost ActiveX controls.

pls advise

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
  #17  
Old March 6th 07, 07:06 AM posted to microsoft.public.excel.programming
NickHK
external usenet poster
 
Posts: 4,391
Default VBA password

Editing a binary in text mode will probably lead to corruption, as you have
found.
Basically, you can't bypass security like this, unless your understand more
about the Excel File Format.
Get the password from the author and enter it correctly.

NickHK

<abelard> wrote in message ...
> Hi
>
> I have used maxedit to change as per list below
>
> CMG=....
> DPB=...
> GC=...
>
> and i got the below errors
>
> An error occured initialising the VBA libraries (2)
>
> icrosoft Office Excel File Repair Log
>
> Errors were detected in file 'C:\Documents and Settings\user\Desktop\lby

E2004.xls'
> The following is a list of repairs:
>
> Lost Visual Basic project.
> Lost ActiveX controls.
>
> pls advise
>
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com



  #18  
Old March 6th 07, 08:19 AM posted to microsoft.public.excel.programming
cdelfino
external usenet poster
 
Posts: 1
Default Retaining Rows based on Array Value

Below codes was a modified version that i got here to delete rows
based on the ColVal array...however need to revised this that instead
of deleting/removing rows based on the ColVal values, they should be
the one retained not removed. How can I do that?? Any help is
appreciated...


ColVal = Array( _
"VAL1", "VAL2", "VAL3", _
)

DeleteRow_Autofilter ColVal, LastRow

---

Sub DeleteRow_Autofilter(ColVal As Variant, LastRow As Long)

Dim Rng As Range
Dim I As Long

For I = LBound(ColVal) To UBound(ColVal)
ActiveSheet.Range("E1:E" & LastRow).AutoFilter Field:=1,
Criteria1:=ColVal(I)
With ActiveSheet.AutoFilter.Range
Set Rng = Nothing
On Error Resume Next
Set Rng = .Offset(1, 0).Resize(.Rows.Count - 1, 1) _
.SpecialCells(xlCellTypeVisible)
On Error GoTo 0
If Not Rng Is Nothing Then Rng.EntireRow.Delete
End With
Next I

ActiveSheet.AutoFilterMode = False
End Sub

  #19  
Old March 6th 07, 01:29 PM posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
 
Posts: 35,218
Default Retaining Rows based on Array Value

I wouldn't use Autofilter for this:

Option Explicit
Sub DeleteRow2()

Dim Rng As Range
Dim iRow As Long
Dim myArr as variant
dim res as variant
dim FirstRow as long
dim LastRow as long

myArr = array("VAL1", "VAL2", "VAL3")

with activesheet
firstrow = 1
lastrow = .cells(.rows.count,"E").end(xlup).row
for irow = lastrow to firstrow step -1
res = application.match(.cells(irow,"E").value, myArr,0)
if isnumeric(res) then
'found it, do nothing
else
'not in myarr
.rows(irow).delete
end if
next irow
end with

End Sub

cdelfino wrote:
>
> Below codes was a modified version that i got here to delete rows
> based on the ColVal array...however need to revised this that instead
> of deleting/removing rows based on the ColVal values, they should be
> the one retained not removed. How can I do that?? Any help is
> appreciated...
>
> ColVal = Array( _
> "VAL1", "VAL2", "VAL3", _
> )
>
> DeleteRow_Autofilter ColVal, LastRow
>
> ---
>
> Sub DeleteRow_Autofilter(ColVal As Variant, LastRow As Long)
>
> Dim Rng As Range
> Dim I As Long
>
> For I = LBound(ColVal) To UBound(ColVal)
> ActiveSheet.Range("E1:E" & LastRow).AutoFilter Field:=1,
> Criteria1:=ColVal(I)
> With ActiveSheet.AutoFilter.Range
> Set Rng = Nothing
> On Error Resume Next
> Set Rng = .Offset(1, 0).Resize(.Rows.Count - 1, 1) _
> .SpecialCells(xlCellTypeVisible)
> On Error GoTo 0
> If Not Rng Is Nothing Then Rng.EntireRow.Delete
> End With
> Next I
>
> ActiveSheet.AutoFilterMode = False
> End Sub


--

Dave Peterson
  #20  
Old March 6th 07, 01:30 PM posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
 
Posts: 35,218
Default crack vba password

Use your backup file.

Talk to the developer and get the password.

abelard wrote:
>
> i had tried with maxedit and when i open the file, the below error display
>
> An error occured when initialising vba libraries
>
> Microsoft Office Excel File Repair Log
>
> Errors were detected in file 'C:\Documents and Settings\user\Desktop\E2004_04.xls'
> The following is a list of repairs:
>
> Lost Visual Basic project.
> Lost ActiveX controls.
>
> pls advise
>
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Password crack in Excel File>VB Editor Hardik Shah Excel Discussion (Misc queries) 4 June 30th 07 10:48 PM
Password Crack Eric Fehlhaber Excel Discussion (Misc queries) 68 August 25th 05 12:52 PM
How can I Crack Excel File Password? Hardik Shah[_2_] Excel Programming 4 May 17th 05 06:17 PM
excel password crack bobf Excel Discussion (Misc queries) 3 April 14th 05 01:57 PM
Crack a VBA password? trickdos[_8_] Excel Programming 4 July 26th 04 08:40 AM


All times are GMT +1. The time now is 01:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.