Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Network:
Windows 2008 Server
>I seem to have a problem automating Excel. What i want is to select the first row in a
> range and make it bold.
>
>I know this is simple, but everything I have tried thus far does not work. By the way, the
> number of columns vary, so I want to select the entire range and make it bold.
>
>Best,
>
>James
The best way to figure out how to do anything with Excel (or Word, or Outlook) is to go into Excel, start recording a macro, do what you want, and then stop recording the macro. Then go in to the macros and look at the source code. If there are any "xlValue" constants, press F8 and then hover over them to get the hard value.
That VB-like code Excel generates is almost directly insertable into VFP for use.
You'll find the code for performing the bold to be pretty straight-forward by looking at the macro code.
HTH!
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