Consistant width for bom column in drawing 1

[jbknudsen]

Greetings to all, I have a bom that has been modified in Excel to match colums widths in conjunction to our drawing t-block. When the bom is inserted in the dwg, the coulums all "autosize". Is there a system variable or option that needs to adjusted in SW or Excel.
SW -2001+ sp4.0
Excel -2000 (9.0.3821 sr-1)

Thanks,
Jay

 

[SBaugh]

Not that I'm aware of...maybe you can write a macro or a program to do that. Scott Baugh, CSWP
credence69@REMOVEhotmail.com

http://www.3dmca.com

http://home.insightbb.com/~scott.baugh/

*When in doubt always check the help*

 

[Standing]

Check out thread thread559-32277 Bradley

 

[SnowCrash]

I have the same problem. I wrote a macro within the template bom.xls to size the columns the way we need them. After you insert the bom just run the macro.

Crashj 'easy for me to say' Johnson

 

[tstanley]

Thanks for the tip about macros. That was easy and worked for me. (and now if I could get rid of those macro warnings.)

 

[jbknudsen]

Thanks to all for the help. It appears that a macro is the way to go. I'll give it a try.

Thanks again

Jay