doing workbook.password for another file without opening it

[lezawang]

Hi
I understand the code below, thanks for you help. but I am wondering if I can do the same without physically opening the file? is that possible?

Sub openandpwd()
Dim x As Workbook
Set x = Application.Workbooks.Open("C:\abc.xlsx")
x.Password = InputBox("enter pass")
x.Close
End Sub

source: https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.password

 

[Joe4]

If you are not opening the file, then what is the point of applying the password?
You apply the password to open the file, so if you do not want to open the file, then what would you be doing with the password and why?
What is the end goal here?

 

[lezawang]

Thanks for your reply. I see your point. But what I want to practice or thought I can do, is for example, print a file without opening it, protect a workbook without open it, unprotected a workbook without opening it. Thanks once again

 

[Joe4]

Why the aversion to opening it up to work on it?

Since you are using VBA anyway, it should be easy enough to open the file, do what you need to do, then close the file again.
So the file would only be open briefly, while the VBA code runs.