i would like to know how would i open Password Protected Excel file.
i have macro to the point that it will open the excel sheet to thepoint of entering the password.
Obviosly i have the Password to open the excel sheet which i am entering manually.
Please help