Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bold First Row in Excel
Message
From
21/05/2013 12:54:36
 
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01574399
Message ID:
01574404
Views:
45
>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!
Previous
Reply
Map
View

Click here to load this message in the networking platform