View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ianripping[_67_] ianripping[_67_] is offline
external usenet poster
 
Posts: 1
Default Open workbook that is protected with password

Hi I have a workbook that is saved with a password.

I want to create a macro that will opne up this file because it know
the password, eg:

Dim password
password = "letmein"
Dim path
Dim filename
Workbook.open = path & filename 'With password!

Can anyone help with this

--
Message posted from http://www.ExcelForum.com