ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Check the value of Password (https://www.excelbanter.com/excel-programming/376427-check-value-password.html)

amit

Check the value of Password
 
Can I make a sub-routine to check the Password required to Open the Word
Document?
Actually I want that the password to open a particular document changes
(every time it is openend). The password should be from an already supplied
list (minimum three passwords).
I know to supply the password using VB but dont know how to check the
existing password, so that I can use 'IF' to change the Password.

Please help!

NickHK

Check the value of Password
 
If this a Word question, you're in the wrong group, but....
If you think about it, being able to check the existing password would be a
pretty stupid capability, as then the password would be useless.
What you can do is use the password(s) you have and trap the error if the
opening fails.

NickHK

"Amit" wrote in message
...
Can I make a sub-routine to check the Password required to Open the Word
Document?
Actually I want that the password to open a particular document changes
(every time it is openend). The password should be from an already

supplied
list (minimum three passwords).
I know to supply the password using VB but dont know how to check the
existing password, so that I can use 'IF' to change the Password.

Please help!




amit

Check the value of Password
 
See Nick

U didnt get the point. Its not only about word. its about using VB!
Other thing is that I am the one supplying Password. So, there ought to be
some way out!

"NickHK" wrote:

If this a Word question, you're in the wrong group, but....
If you think about it, being able to check the existing password would be a
pretty stupid capability, as then the password would be useless.
What you can do is use the password(s) you have and trap the error if the
opening fails.

NickHK

"Amit" wrote in message
...
Can I make a sub-routine to check the Password required to Open the Word
Document?
Actually I want that the password to open a particular document changes
(every time it is openend). The password should be from an already

supplied
list (minimum three passwords).
I know to supply the password using VB but dont know how to check the
existing password, so that I can use 'IF' to change the Password.

Please help!





NickHK

Check the value of Password
 
Again, this is an Excel group, not Word, but....

You say "I know to supply the password using VB", so what is the problem
then ?

NickHK

"Amit" wrote in message
...
See Nick

U didnt get the point. Its not only about word. its about using VB!
Other thing is that I am the one supplying Password. So, there ought to be
some way out!

"NickHK" wrote:

If this a Word question, you're in the wrong group, but....
If you think about it, being able to check the existing password would

be a
pretty stupid capability, as then the password would be useless.
What you can do is use the password(s) you have and trap the error if

the
opening fails.

NickHK

"Amit" wrote in message
...
Can I make a sub-routine to check the Password required to Open the

Word
Document?
Actually I want that the password to open a particular document

changes
(every time it is openend). The password should be from an already

supplied
list (minimum three passwords).
I know to supply the password using VB but dont know how to check the
existing password, so that I can use 'IF' to change the Password.

Please help!







Greg Glynn

Check the value of Password
 
Yeah,

We EXCEL guys don't like to mix with you WORD guys ... We're deeply
suspicious of you, and you're all Funny Lookin'

;-)


Greg


NickHK wrote:
Again, this is an Excel group, not Word, but....

You say "I know to supply the password using VB", so what is the problem
then ?

NickHK

"Amit" wrote in message
...
See Nick

U didnt get the point. Its not only about word. its about using VB!
Other thing is that I am the one supplying Password. So, there ought to be
some way out!

"NickHK" wrote:

If this a Word question, you're in the wrong group, but....
If you think about it, being able to check the existing password would

be a
pretty stupid capability, as then the password would be useless.
What you can do is use the password(s) you have and trap the error if

the
opening fails.

NickHK

"Amit" wrote in message
...
Can I make a sub-routine to check the Password required to Open the

Word
Document?
Actually I want that the password to open a particular document

changes
(every time it is openend). The password should be from an already
supplied
list (minimum three passwords).
I know to supply the password using VB but dont know how to check the
existing password, so that I can use 'IF' to change the Password.

Please help!





amit

Check the value of Password
 
So MR. EXCEL!!!!!!!!

Get it this way- "I want to change the Password of a workbook I created
every time it is closed. And that password should be from a specified list
and should follow a certain pattern"

OK then, I hope that Mr. Excel will sort out the problem. If you are not
able to solve the problem then I suggest you to be careful and understand the
nature of the problem before making any comment.

Other thing is that I use a variety of Softwares varying from Analysis to
Excel and Drafitng to Word. And I know each software has its own applications
and standing!!!!!!

"Greg Glynn" wrote:

Yeah,

We EXCEL guys don't like to mix with you WORD guys ... We're deeply
suspicious of you, and you're all Funny Lookin'

;-)


Greg


NickHK wrote:
Again, this is an Excel group, not Word, but....

You say "I know to supply the password using VB", so what is the problem
then ?

NickHK

"Amit" wrote in message
...
See Nick

U didnt get the point. Its not only about word. its about using VB!
Other thing is that I am the one supplying Password. So, there ought to be
some way out!

"NickHK" wrote:

If this a Word question, you're in the wrong group, but....
If you think about it, being able to check the existing password would

be a
pretty stupid capability, as then the password would be useless.
What you can do is use the password(s) you have and trap the error if

the
opening fails.

NickHK

"Amit" wrote in message
...
Can I make a sub-routine to check the Password required to Open the

Word
Document?
Actually I want that the password to open a particular document

changes
(every time it is openend). The password should be from an already
supplied
list (minimum three passwords).
I know to supply the password using VB but dont know how to check the
existing password, so that I can use 'IF' to change the Password.

Please help!







All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com