rlx Posted June 25, 2015 Posted June 25, 2015 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 Quote
Lee Mac Posted June 25, 2015 Posted June 25, 2015 The Range Object is derived from the Excel Worksheet Object. Quote
rlx Posted June 25, 2015 Author Posted June 25, 2015 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 Quote
rlx Posted June 25, 2015 Author Posted June 25, 2015 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 Quote
rlx Posted June 29, 2015 Author Posted June 29, 2015 Maby not pretty (like myself ) but it does the job for me. Greetz paste from excel.LSP Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.