Scalabium Software

SMExport advertising
Knowledge for your independence'.
Home Delphi and C++Builder tips

#153: To open the password-protected xls-file and save without password

Today I want to show how you may load some xls-file that is password-protected, and how to save xls into another file but without protection.

  xls, xlw: Variant;
  {load MS Excel}
  xls := CreateOLEObject('Excel.Application');

  {open your xls-file}
  xlw := xls.WorkBooks.Open(FileName := 'd:\book1.xls', Password := 'qq',
ReadOnly := True);
  {save with other file name}
  xlw.SaveAs(FileName := 'd:\book2.xls', Password := '');

  {unload MS Excel}
  xlw := UnAssigned;
  xls := UnAssigned;

Just replace there file names and password

Published: December 30, 1899

See also
Fast Document Viewer
SMImport suite
Database Information Manager
ABA Spreadsheet Convert
Paradox Viewer
SMExport suite
dBase Viewer
ABA Picture Convert
Paradox ActiveX

Contact to webmaster


Borland Software Code Gear Scalabium Delphi tips

Copyright© 1998-2018, Scalabium Software. All rights reserved.

SMExport advertising