View Single Post
 
Old 03-04-2006, 01:30 AM
paulrm906 paulrm906 is offline
Novice
 
Join Date: Mar 2006
Posts: 3
paulrm906
Default Macros & Passwords

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
Reply With Quote