Showing results for 
Search instead for 
Did you mean: 

How to save as a password project VBA macro enabled excel to text file

Hello All,

I'm trying to read the content from an excel file which has VBA Project with Password protection. When I try to Save the excel as text file its throwing an error code "-2146827284". If i remove the password for VBA project I could able to save the excel as text file. Is there is any option to Unlock Password for macro and copy it to text and lock the macro again.


I have attached my vi for you reference. 


0 Kudos
Message 1 of 3

Thank you Madhan


But What I'm searching is not for Password protected worksheet its actually password protected VBE (Visual Basic Editor). 

0 Kudos
Message 3 of 3