Unprotect workbooks

[Nelson]

We receive Excel workbook files every day which are password protected with
the same password. We know this password. Is there a utility or method to
remove password protection on these workbook files without invoking
Excel.exe or the Excel object. Our goal is to take Excel out of the process
and utilize SpreadsheetGear in VB.net. However, SpreadsheetGear can only
unprotect worksheets not workbooks.

Thanks



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4326 (20090811) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

[JLGWhiz]

I am pretty sure you have to instantiate the application to get to the
workbook and remove the protection.