How do I write a Subroutine to check
if the file needs a password to open, then I supply the password (inside the Sub when the file when opening) to open,
and in case no password needed, just open the file
I want a code to check if the file is has password protected for opening, and if yes, then
Workbooks.Open Filename:="C:\name.xls", Password:="My_Password"