Opening a password protected Excel sheet using VB code
Posted by Varun Pant on November 20, 2001 9:49 PM
I want to open a password protected excel sheet using VB code, and have been successful in opening the worksheet, but it still prompts for the password everytime I want to open it. Is there a way to automate this with code, so that the password is hard coded in the VB program, and does not prompt for the password. I mean something like sendkey method, but it seem that it is not supported in excel. Thanks in advance.