Solution
Yes, there is a way to do this using the ActiveX functions.
Note: This image is a LabVIEW snippet, which includes LabVIEW code that you can reuse in your project. To use a snippet, right-click the image, save it to your computer, and drag the file onto your LabVIEW diagram.
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.