Information générale
Catégorie:
COM/DCOM et OLE Automation
>Hello,
>
>I have several questions about Automation in Excel.
>
>1. I'd like to know how I can change the background and foreground color of a cell?
>
>2. How can I insert a new column?
>
>3. How can I print the same header on every page when I print my Excelsheet?
>
The best way to answer questions like this yourself is to record a macro doing the task interactively and then examine it to see what objects and properties it uses. In addition, the Excel VBA Help file will give you lots of information.
For your first question, check out the Font object.
To insert a column, look at the Insert method.
For the last question, check out the PageSetup object, in particular, the xxxHeader and xxxFooter properties.
Tamar
Précédent
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