How to export data to excel wiht password?

[n1br]

Please,

If anyone knows how to export data to excel with password in Delphi 7, I would thank a lot.

I tried this code but I have no tutorial to know if there
is a parameter to protect the excel file. In case it's possible to export with password, how I would import protected files?


Thanks.


msexcel:=CreateOleObject('excel.application');
excelbook:=msexcel.workbooks.add;
msexcel.ActiveWorkbook.Names.Add('test', '=Sheet1!$A$1:$D$3', EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam);

 

[jberube]

Here is how I open a password protected execl file:

ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Open(MyPath + MyFile, EmptyParam, EmptyParam,
EmptyParam, MyPassword, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, LCID));