View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eroszzz eroszzz is offline
external usenet poster
 
Posts: 1
Default Visual Basic Macro(VBA) for a password protected file?


How do I create a Visual Basic Macro(VBA) for a password protected file
I essentially want the VBA to open the file, update the links and sav
it. But when I run the VBA, it forces me to type in the password fo
my file. Since the VBA is going to open about 20 files, if I have t
type the password in every time, it defeats the purpose of the VBA.
Can anyone please help me? Thank you so very much

--
eroszz
-----------------------------------------------------------------------
eroszzz's Profile: http://www.excelforum.com/member.php...nfo&userid=846
View this thread: http://www.excelforum.com/showthread.php?threadid=39340