Write to a Password Protected Excel File so That the Password Prompt Is Bypassed Programmatically

Updated Nov 7, 2023

Reported In

Software

  • LabVIEW

Issue Details

Is there a way to write to a password protected Excel file so that the password prompt is bypassed programmatically in LabVIEW?

Solution

Yes, there is a way to do this using the ActiveX functions.



Here Password refers to a password that may be applied to an excel workbook. Whereas WriteResPassword refers to a password that may be applied to a specific sheet.
The password to this excel document was set to "123" which should be changed accordingly.

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.