setting excel password using VBA

hi all

can anyone tell me how to specify excel password using VBA code

Thanks

Regards

Vani

Vani,

What type of password.. Protection password, workbook password, opening a workbook with a password ?

I am looking for a way to set the DB link password automatically. When in an Excel macro the Userid is already set and the Server, but I have to keep entering the Password, this won't change, and is annoying. Can I set it in code???
Thanks :wave:

There are several password types: Workbook, edit password, protected passwords etc. If you are trying to open a workbook then just supply the needed password in the arguments of the open method.