Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creation of excel file
Message
From
10/05/2013 16:00:42
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01573434
Message ID:
01573485
Views:
44
>>>>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 && Works in Excel 2003
>	endif
>
>	loExcel.save()
>
Thank you Naomi
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Reply
Map
View

Click here to load this message in the networking platform