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" <(E-Mail Removed)> wrote in message
> > news
3993975-9212-46A0-A178-(E-Mail Removed)...
> > > 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" <(E-Mail Removed)> wrote in message
> > > > news:1F4C6696-4A52-444B-B732-(E-Mail Removed)...
> > > > > 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!
> > > >
> > > >
> > > >
>
>