lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
Can I do exactly the same as below (assign password to a file) without opening it? I do not want to open it. Is that possible? Thank you so much.
Sub myopening()
Dim x As Workbook
Set x = Workbooks.Open("c:\testing.xlsx")
x.Password = 123
End Sub
Can I do exactly the same as below (assign password to a file) without opening it? I do not want to open it. Is that possible? Thank you so much.
Sub myopening()
Dim x As Workbook
Set x = Workbooks.Open("c:\testing.xlsx")
x.Password = 123
End Sub