>>>Hello all,
>>>
>>>I create a cursor and then I do the following
>>>
>>>COPY TO NameOfFile TYPE xls
>>>
>>>Is there a way to add programmatically a password to that file?
>>>
>>>Oh and by the way that file will be read by LibreOffice.
>>
>>You can do this using Excel Automation. Let me know if this is the solution you can use.
>
>Hello Naomi,
>
>I guess that would have to be the solution. I'll see if I can find some code to help me. Feel free to send me code or a link if you can help me a bit more. Thanks
This is my old code
if not empty(m.tcPassword)
loExcel.ActiveWorkbook.password = m.tcPassword
endif
loExcel.save()
If it's not broken, fix it until it is.
My Blog