rlx Posted June 25, 2015 Share 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 Link to comment Share on other sites More sharing options...
Lee Mac Posted June 25, 2015 Share Posted June 25, 2015 The Range Object is derived from the Excel Worksheet Object. Quote Link to comment Share on other sites More sharing options...
rlx Posted June 25, 2015 Author Share 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 Link to comment Share on other sites More sharing options...
rlx Posted June 25, 2015 Author Share 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 Link to comment Share on other sites More sharing options...
rlx Posted June 26, 2015 Author Share Posted June 26, 2015 yip , it works , thanx Lee Quote Link to comment Share on other sites More sharing options...
Lee Mac Posted June 26, 2015 Share Posted June 26, 2015 You're welcome Quote Link to comment Share on other sites More sharing options...
rlx Posted June 29, 2015 Author Share Posted June 29, 2015 Maby not pretty (like myself ) but it does the job for me. Greetz paste from excel.LSP Quote Link to comment Share on other sites More sharing options...
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.