Dear all
Im trying to connect to an excel file using vb.net, but the excel file is in macro password protected, which mean someone had write an macro which will prompt the user to input the password when the workbook is being open!
Can anyone please tell me how i can pass the password to this excels marco, so that my vb program can access the data in there?
Thx alot
Jack
Im trying to connect to an excel file using vb.net, but the excel file is in macro password protected, which mean someone had write an macro which will prompt the user to input the password when the workbook is being open!
Can anyone please tell me how i can pass the password to this excels marco, so that my vb program can access the data in there?
Thx alot
Jack