Scalabium Software

SMReport Autogenerated

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.

var
  xls, xlw: Variant;
begin
  {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;
end;

Just replace there file names and password


Published: December 30, 1899

See also
 
Viewer for TNEF-files (winmail.dat)
Mail parser (ActiveX)
Paradox to MS Access converter
SMMsg suite
ABA Database Convert
Paradox Password Recovery
DBExport tools
DBLoad
DBISAM Password Recovery
dBase Viewer
 
 
Contact to webmaster

 

Borland Software Code Gear Scalabium Delphi tips

Copyright© 1998-2014, Scalabium Software. All rights reserved.
webmaster@scalabium.com

SMReport Autogenerated