setting excel password using VBA

[vanisehgal]

hi all

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

Thanks

Regards

Vani

[dannymking]

Vani,

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

[DebbieInFlorida]

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

[RobDog888]

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.