how to open password protected excel 2010 with vba acces 2010

[viperman]

i have file work.xlsx with password="1234". how to open with vba access.....???

 

[pr2-eugin]

Hello viperman, Welcome to AWF..

So just wondering, if you did a simple Google search? I did and it gave me several hits..

http://www.mrexcel.com/forum/excel-...pplications-open-password-protected-file.html

 

[viperman]

thank a lot pr2-eugin
after i try this code. i can't see file work.xlsx.
when open other file example: nice.xlsx with double click or manually, file work.xlsx join coincided with nice.xlsx
can u explain this ??

 

[pr2-eugin]

Coming a bit dry there.. Could you show the code you have?

Thought you are automating the process of opening an Excel file.. Where did this Double Click come from?

What exactly do you mean by you cannot see work.xlsx? Where are you operating this code from?