VBA Oops

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I inhereted an Excel spreadsheet from a previous employee. The VBA is
password protected. Does anyone know a way around the password? I would
HATE to re-create the entire sheet.
 
Hi Rip

There is no easy code way around this (and if it was then I'd deliberately
lie about it). This has to do with property:
- The employe made the code on company equipment in company hours. Just call
her, the password belongs to the company, not to the former employee.
- The employee made the code on personal eqipment in her free time. The code
is hers, not yours, and reusing it is theft.
- Something inbetween. You should talk.

HTH. Best wishes Harald.
 
I understand your statement. We have an unresolvable issue. The work was
done on company time on a company machine. I cannot ask for his password as
the person in question passed away due to a heart attack. I am just a guy
the company brought in to clean up the mess, so to speak.

Should anyone have any tips it would be greatly appreciated. I DO NOT want
to invest the time needed to re-create this work.

Thanks,
RIP

Harald Staff said:
Hi Rip

There is no easy code way around this (and if it was then I'd deliberately
lie about it). This has to do with property:
- The employe made the code on company equipment in company hours. Just call
her, the password belongs to the company, not to the former employee.
- The employee made the code on personal eqipment in her free time. The code
is hers, not yours, and reusing it is theft.
- Something inbetween. You should talk.

HTH. Best wishes Harald.
Click to expand...
 
It's been a long time since I encountered this problem, so my data may
be out of date. But in the past, there used to be companies listed in
the small ads (called "business card" ads) in the back of major
computer magazines like PC Magazine that did this sort of thing. They
charged about $500 some years back.
I also had a friend who solved this problem very creatively. He knew
neighbors who had teenage kids. He asked the kids who was the best
hacker they knew. He got in touch with the kid, and for the cost of a
video game (~$50), the kid came up with the password in no time! Some
may frown on this, but I found it very creative and the cause was
legit. Maybe it even showed the kid, if he had larcenious intentions
for his skills, that he could make money legitimately.
 
Four Solutions:
1.. Ask the people in the newsgroup Microsoft.public.excel.programming.
2.. Visit a psychic and ask the dead guy for the password.
3.. Call his spouse and ask for the names of his pets from his childhood.
4.. Pay "Da Man" if you can't or don't have time to recreate the code.
DOG

Ripper said:
I understand your statement. We have an unresolvable issue. The work was
done on company time on a company machine. I cannot ask for his password as
the person in question passed away due to a heart attack. I am just a guy
the company brought in to clean up the mess, so to speak.

Should anyone have any tips it would be greatly appreciated. I DO NOT want
to invest the time needed to re-create this work.

Thanks,
RIP
Click to expand...
 
I'm really sorry to hear this.
There are several commercial options at
http://www.google.com/search?hl=en&q=vba+password
you may find a reasonable deal there.

Most regulars here write code to get food on the table, so I ask for your
understanding regarding not publishing DIY solutions to this.

Best wishes Harald

Ripper said:
I understand your statement. We have an unresolvable issue. The work was
done on company time on a company machine. I cannot ask for his password as
the person in question passed away due to a heart attack. I am just a guy
the company brought in to clean up the mess, so to speak.

Should anyone have any tips it would be greatly appreciated. I DO NOT want
to invest the time needed to re-create this work.

Thanks,
RIP
Click to expand...
 
1.. Ask the people in the newsgroup Microsoft.public.excel.programming.

By and large pretty much the same audience, who will give the same advice
that Harald did.
 
Uzytkownik "davegb said:
It's been a long time since I encountered this problem, so my data may
be out of date. But in the past, there used to be companies listed in
the small ads (called "business card" ads) in the back of major
computer magazines like PC Magazine that did this sort of thing. They
charged about $500 some years back.
I also had a friend who solved this problem very creatively. He knew
neighbors who had teenage kids. He asked the kids who was the best
hacker they knew. He got in touch with the kid, and for the cost of a
video game (~$50), the kid came up with the password in no time! Some
may frown on this, but I found it very creative and the cause was
legit. Maybe it even showed the kid, if he had larcenious intentions
for his skills, that he could make money legitimately.
Click to expand...

you may try this one
Advanced Office XP Password Recovery Pro v2.40
rgds
mcg
 
Back
Top