Jump to content
rlx

excel 'ColumnWidth property

Recommended Posts

rlx

Does anybody know how to retrieve / handle this?

 

(vlax-get-property rangeobject 'ColumnWidth)

 

i dont know how the rangeobject must look like

 

thanx in advance

Share this post


Link to post
Share on other sites
Lee Mac

The Range Object is derived from the Excel Worksheet Object.

Share this post


Link to post
Share on other sites
rlx

Lee,

 

 

yes , this i know

 

 

(setq ExcelRange (vlax-get-property ExcelApp "Range" range))

 

 

so if i use something like "A1" or "A" or "A1:A1" for the range parameter then this should work?

 

 

(setq width (vlax-get-property ExcelRange 'ColumnWidth))

 

 

unfortunately i was already late for diner so i had to hurry home and had no time

to mail my routine to my house but tomorry it will be the first thing i do

 

 

thanx

Share this post


Link to post
Share on other sites
rlx
Lee,

 

 

yes , this i know

 

 

(setq ExcelRange (vlax-get-property ExcelApp "Range" range))

 

 

so if i use something like "A1" or "A" or "A1:A1" for the range parameter then this should work?

 

 

(setq width (vlax-get-property ExcelRange 'ColumnWidth))

 

 

unfortunately i was already late for diner so i had to hurry home and had no time

to mail my routine to my house but tomorry it will be the first thing i do

 

 

thanx

 

 

 

btw , rlx is short for Robert Luykx

Share this post


Link to post
Share on other sites
rlx

yip , it works , thanx Lee

Share this post


Link to post
Share on other sites
Lee Mac

You're welcome :)

Share this post


Link to post
Share on other sites
rlx

Maby not pretty (like myself :notworthy:) but it does the job for me.

 

 

Greetz

paste from excel.LSP

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×