LabVIEW

cancel
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. 

Excel_To_Txt.png

0 Kudos
Message 1 of 3
(3,097 Views)

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
(3,018 Views)