<alon1...@gmail.com> wrote in message
news:1170590415.9...@q2g2000cwa.googlegroups.com...
> 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
>
RBS
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
RBS
"Antonio" <Ant...@discussions.microsoft.com> wrote in message
news:8F7402CE-A17A-4772...@microsoft.com...
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" <Ant...@discussions.microsoft.com> wrote in message
news:8F7402CE-A17A-4772...@microsoft.com...
I did try on a test file.
It works.
Quite handy.
D/ALLEN
First of all my appreciation for your genorosity in sharing with ur
find. First time it was all greek. I read it over and over again to
ustand a bit. Now i got the hex editor xvi32. I ran it and did as u
told. When i opened the excel file in the hex editor-- there was
three screens, one small to the left, and next two big ones. in the
thrid one only ascii characters. But i did not find what u said like
CMG=....
> DPB=...
> GC=...
Then i clicked on the tools on xvi32 and opened the editor. i got
only four characters.
So can u adopt the approach - ALLEN STEPS FOR DUMMIES--. Pls explain
it in little more detail especially since I cant find the CMG=....
DPB=... GC=.... I think I am not opening it in the right screen.
Pls advice
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.
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" <Anto...@discussions.microsoft.com> wrote in message
>
> news:8F7402CE-A17A-4772...@microsoft.com...
>
>
>
> > 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
>
> > "alon197...@gmail.com" 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 -
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" <jcol...@franciscan.edu> wrote in message
news:1170675266.2...@s48g2000cws.googlegroups.com...
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
Talk to the developer and get the password.
--
Dave Peterson