Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2006, 01:30 AM
paulrm906 paulrm906 is offline
Novice
Macros & Passwords
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros & Passwords Outlook 2002 Forgetting Passwords in VISTA efk3 Outlook 2 09-01-2008 03:19 PM
Macros problem with XP Gretchen Hembree Excel 8 02-17-2006 02:56 PM
Self Help Books for Macros? KRB Excel 0 11-22-2005 01:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft