Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creation of excel file
Message
 
 
À
10/05/2013 13:46:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01573434
Message ID:
01573472
Vues:
45
>>>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()
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform