Macros & Passwords
 

Hello
I have a macro that opens many files/saves and closes them but is there
a way of opening a file with a password using a macro without having to
enter the password when the macro ask you. So other words is it
possible to have the password written into the actual macro itself.

Thanks in advance,

Paul Maynard
Moscow
Russia.


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=518608

Macros & Passwords
 

hi,
open the vb editor (alt + F11). click help (in the vb editor). in the search
box, type "open method".
It will explain how to add the Password in the open statement used by the
macro.

regards
FSt1

"paulrm906" wrote:


Hello
I have a macro that opens many files/saves and closes them but is there
a way of opening a file with a password using a macro without having to
enter the password when the macro ask you. So other words is it
possible to have the password written into the actual macro itself.

Thanks in advance,

Paul Maynard
Moscow
Russia.


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=518608

Macros & Passwords
 

Hello FStl

I have gone into help tried everything that I could but I do not seen
to be getting anywhere. Everything that I try it keeps asking me for
the password that I am opening. Below is a copy of the actual macro, if
I can get help from you or anyone it will be greatly appreciated.

Sub Auto_Open()
'
' Auto_Open Macro
' Macro recorded 4/03/2006 by Paul Maynard
'

'
Workbooks.Open Filename:= _
"E:\Documents and Settings\anna\Desktop\Paul\Work\111.xls"
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub


Thanks

Paul Maynard
Moscow
Russia.


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=518608