Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bold First Row in Excel
Message
De
21/05/2013 12:54:36
 
 
À
21/05/2013 12:33:51
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01574399
Message ID:
01574404
Vues:
49
>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
Fil
Voir

Click here to load this message in the networking platform