Read Password Protected Excel Cell Using VBScript
Posted on 2010-09-16
I have created a script that runs during an install of an Excel add-in, and would now like to perform some version checking of the add-in. I have the current installed version stored in the registry, so accessing that is easy. The method that I am using to extract the version of the add-in that is being installed is by reading a couple of cells in a sheet inside the .xla file.
The question I have is how can I read the cells on a sheet inside a password protected .xla file using VBScript?