How Can I Remove the Password When Opening an Excel Spreadsheet?

re: How Can I Remove the Password When Opening an Excel Spreadsheet?

Bob — Tue, 12 Mar 2013 13:13:44 GMT

This script is fantastic! Any suggestions on how to extend it to work with an entire directory of excel files with the same password required to open them?

re: How Can I Remove the Password When Opening an Excel Spreadsheet?

Cropley — Wed, 12 Dec 2012 12:12:57 GMT

damn it won't work if you lost a password to OPEN spreadsheet!! tried everything but could not do it on my own. had to pay $20 to remove it with online service called www.password-find com. it helped in no time fortunately

re: How Can I Remove the Password When Opening an Excel Spreadsheet?

xx213 — Thu, 24 May 2012 21:14:05 GMT

I wrote this excel version for fun and for free – no installation required. Just open this workbook (www.mann-jones.com/ExcelCracker.aspx) , click Quick Run , navigate to your sheet and voila … workbook and worksheet unprotected.

re: How Can I Remove the Password When Opening an Excel Spreadsheet?

Eddy Jawed — Mon, 08 Aug 2011 13:04:25 GMT

Thanks for this, but I already knew how to 'Open' a password protected excel file using VB. However I am trying to OPEN and the REMOVE the password set on the worksheet permanently and programmatically. Amy ideas how to do this. I already know the password for the sheet, so I'm not trying to hack into it. Just want the thing removed so i can import the worksheet easily afterwards using SSIS.

Cheers

Eddy

re: How Can I Remove the Password When Opening an Excel Spreadsheet?

SmartKey — Mon, 20 Dec 2010 09:43:02 GMT

thanks for your post, i think remove the password using scripts is a little difficult for freshman, if anyone forgot the excel password can try some excel password recovery tool, which can recover Microsoft Excel passwords, enabling you to easily view the workbooks and sheets for the information.