Link to home
Start Free TrialLog in
Avatar of Jagwarman
Jagwarman

asked on

VBA to open Excel file that contains a password

Can an Expert provide me with VBA code that will enable the Macro to open the file that contains a password.

Lets say the password is Holiday1 and it will always be that.

When I open the file I get the window up that asks me for the password. Instead of the User entering the password can the VBA code insert the password to open the file?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Hakan Yılmaz
Hakan Yılmaz
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial