Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 03-04-2006, 01:30 AM
paulrm906 paulrm906 is offline
Macros & Passwords
Join Date: Mar 2006
Posts: 3
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"

End Sub

Thanks in advance'

Paul Maynard
Reply With Quote

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 12:24 PM.

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