Macro & Password
 

Hello everyone

I have made a macro which opens a file with a password (this is to
update it) then saves it and then closes, unfortunately I can not get
it to open without asking me for a password. I have already tried lots
of differant things but nothing works. Below I have pasted a copy of
the macro and just hope that some one can help me.

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 in advance'

Paul Maynard
Moscow


--
paulrm906

Macro & Password
 

Paul,
Try...
Workbooks.Open Filename:= _
"E:\Documents and Settings\anna\Desktop\Paul\Work\111.xls", Password:="MySecret"

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"paulrm906"
wrote in message...
Hello everyone
I have made a macro which opens a file with a password (this is to
update it) then saves it and then closes, unfortunately I can not get
it to open without asking me for a password. I have already tried lots
of differant things but nothing works. Below I have pasted a copy of
the macro and just hope that some one can help me.

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 in advance
Paul Maynard
Moscow
paulrm906

Macro & Password
 

Thanks Jim

It works great. did not think it would be something so simple.

Paul Maynard
Moscow.


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