Draw Rectangle depending on Column size

[smiling_kk]

Dear Forum guyz,

I need help on the following Macro which generates VISI
document[Standard 2007 version] with output[attached as document].

The macro reads data from Cols B, D and I and produces a rectangl
consisting of data from the three columns.My input excel contains 10
rows.

PROBLEM: as the column I data may vary from 50 to 250 words.I want t
size of teh rectangle to modified as per the input.

Please help.

Cheers,
K


+-------------------------------------------------------------------+
|Filename: visio output.doc |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=510|
+-------------------------------------------------------------------+

 

[Paul Herber]

Dear Forum guyz,

I need help on the following Macro which generates VISIO
document[Standard 2007 version] with output[attached as document].

The macro reads data from Cols B, D and I and produces a rectangle
consisting of data from the three columns.My input excel contains 100
rows.

PROBLEM: as the column I data may vary from 50 to 250 words.I want to
size of teh rectangle to modified as per the input.

I don't see your attachment, normally this is a text only medium and attachments are
frowned upon.
However, for all sorts of clever things with text like resizing and adjusting shapes to
suit the text have a look at:

http://www.visguy.com/2009/05/06/top-twelve-text-tips/

and associated posts.