Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bold First Row in Excel
Message
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:
01574403
Views:
54
>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

assuming _firstcell_ is the address of the first cell and oxl is Excel, you could try:
oselection = oxl.range(_firstcell_).currentregion.rows(1).select
oselection.font.bold = .t.
there must be a zillion other ways, but this one I've checked :)

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Reply
Map
View

Click here to load this message in the networking platform