General information
Category:
COM/DCOM and OLE Automation
Environment versions
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!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only