ADP- How to import a report or form which is password protected 1

[problemsinadb]

Pampers,

The forms and reports are password protected it seems. luckly we got the password also. When I am trying to import the below dialog box is coming
"Microsoft helps protect this visual basic for applications project with a password. You must supply the password in the visual basic editor before you can perform this operation."

Where to give the password? How?...Hope you have an idea , Sorry, it may be a basic thing, but the adp is a new one to me (even though it is old !!!!!)

Thanks in advance

Jim

 

[PHV]

Have you tried to reference the protected .adp ?
when in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[problemsinadb]

Hi PHV,

Thanks for the reply..
I added the reference, but still i am unable to import the forms and reports which are password protected. The password i know but how to pass it to the source adp?
(I am unable to open the source adp that is why i am trying to import the objects)

Please check the below link..Is it says that it is impossible?

"

http://support.microsoft.com/kb/205085/en-us#appliesto"

thanks
Jim

 

[PHV]

I don't play with adp, but I've referenced a VBEprotected mdb and been able to see the code after providing the password ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886