Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Putting Borders around cells in Excel
Topic Summary:
Created On: 12-Aug-2008 21:05
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 12-Aug-2008 21:05
User is offline View Users Profile Print this message


Scott Boisvert

Posts: 348
Joined: 14-Apr-2006

Anyone know how I would put a thick border around a range of cells once I've all gotten a OleAutoObj for the range of of objects?

-------------------------
Scott Boisvert
Engineering Tools Administrator
L-3 Communications - Avionics Systems
scott.boisvert@l-3com.com
Report this to a Moderator Report this to a Moderator
 12-Aug-2008 21:21
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Sutherland's excel exporter has functions to set a ranges border.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 12-Aug-2008 21:30
User is offline View Users Profile Print this message


Scott Boisvert

Posts: 348
Joined: 14-Apr-2006

That's what I was looking at, and how go the range using his getCellRange function, but can't find anything related to setting a border.

-------------------------
Scott Boisvert
Engineering Tools Administrator
L-3 Communications - Avionics Systems
scott.boisvert@l-3com.com
Report this to a Moderator Report this to a Moderator
 12-Aug-2008 22:13
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Here you go. Sorry. You'll have to find the integer value for bold borders. Just do a macro and add a bold border. Should give the value. If it uses an identifier instead of the value you can google it typically.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com

Edited: 12-Aug-2008 at 22:17 by David Pechacek
Report this to a Moderator Report this to a Moderator
 12-Aug-2008 23:34
User is offline View Users Profile Print this message


Chris Jones

Posts: 177
Joined: 1-Jul-2005

The integer specifying a "Thick" border would be 4. I used the Object Browser in the VBA editor -- there's a group called XlBorderWeight.
Report this to a Moderator Report this to a Moderator
 14-Aug-2008 13:35
User is offline View Users Profile Print this message


Scott Boisvert

Posts: 348
Joined: 14-Apr-2006

This is how I was able to get this to work:

-------------------------
Scott Boisvert
Engineering Tools Administrator
L-3 Communications - Avionics Systems
scott.boisvert@l-3com.com

Edited: 14-Aug-2008 at 14:26 by Scott Boisvert
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.