Many thanks,
Kirill.
You can't, sorry, except with "sendkeys". Search this at
http://groups.google.com/advanced_group_search
("Can't" is; there are no objects in VB /VBA that approaches this lock. If
you use some tool to alter the binary structure of the stored file, and
manage to figure out where and what the possibly encrypted password is, it
might in theory be possible. )
Best wishes Harald
"Kirill Lapin" <lap...@grupobbv.net> wrote in message
news:OCm$qWNKBHA.1268@tkmsftngp05...
Regards,
Tom Ogilvy
Kirill Lapin <lap...@grupobbv.net> wrote in message
news:OCm$qWNKBHA.1268@tkmsftngp05...
What is SendKeys, please?
Many thanks,
Kirill
"Tom Ogilvy" <twog...@email.msn.com> wrote in message
news:e6xUxJOKBHA.1904@tkmsftngp04...
Look up SendKeys in VBA help. Basically, Sendkeys emulates keyboard key
presses.
--
Jeff McAhren
Dallas, Texas
"Kirill Lapin" <lap...@grupobbv.net> wrote in message
news:#BvvH1PKBHA.1728@tkmsftngp02...
The bad news is: You better be sure that you're at the correct program and at
the correct screen with the correct options displayed--otherwise,....
If you send it the correct combination of keys and never touch the
keyboard/mouse while it's executing, you might get lucky.
Bill Manville posted something awhile ago. Look here (on google):
--
Dave Peterson
ec3...@msn.com
As others stated, it's imitating keyboard keypresses.
Here's a macro from my code library. Unfortunately I did not save the
author's name, but it's from one of this group's frequent and brilliant
posters:
Sub deprotect()
Application.SendKeys "%{F11}", True 'opens vbeditor
Application.SendKeys "^r", True 'project window
Application.SendKeys "{DOWN}", True 'down arrow somehow
'makes the password dialog come up.
Application.SendKeys "2", True 'enters the password, here it's 2
Application.SendKeys "{ENTER}", True 'enters the password
'Application.SendKeys "{F5}", True 'run macro
'Application.SendKeys "fixup~", True 'fixup is the name of the
macro
'that doesn't work unless the project is unprotected.
End Sub
Best wishes Harald
Kirill Lapin <lap...@grupobbv.net> skrev i
news:#BvvH1PKBHA.1728@tkmsftngp02...
Thanks a lot for the code. Looks like it only affects the VBAProject in
which the macro is stored. The good thing is that you do not need to protect
the file again when finished working with the project.
Kirill.
"Harald Staff" <harald...@nrk.no> wrote in message
news:emK0j8UKBHA.700@tkmsftngp04...