Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Network:
Windows 2003 Server
>Hi
>Maybe i'm just being a bit dumb on this one. I want to leave the user facing a spreadsheet that has freezpanes and autofilter already set. All the rest of the formatting is done elsewhere in the program, and I just have these two elements to sort out.
>
>Alan
>
>
>*- Finish
>oSheet.PageSetup.PrintArea = "$A$1:$S$8800"
>
>oSheet.Range("A8").Select
>oSheet.FreezePanes = "True"
>
>oSheet.Range("A8:S8800").Select
>oSheet.Selection.AutoFilter
So, why do not you follow the Excel Macro?
There are no statements like oSheet.FreezePanes = "True". And FreezePanes you can apply to the Excel ActiveWindow, not sheet object.
And, sure, if there were already freezepanes, and splitted rows or columns that you wish to change, then you should first unfreeze panes, set split rows/coplumns as needed, and set freezepanes to .t. again.
If you have problems translating the VBA code from MAcro to VFP, then show here what you got in VBA code.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement