sanju2323 Posted March 14, 2016 Share Posted March 14, 2016 (edited) Hello Everyone, I am trying to column "A" where text "TP" is just the place to circle should fall. And the remaining other "code" should fall point. Thank you in advance. Edited March 16, 2016 by sanju2323 Quote Link to comment Share on other sites More sharing options...
BIGAL Posted March 15, 2016 Share Posted March 15, 2016 Just look up how to use concatenate and IF in excel, just copy one column say "J" straight to autocad and all done. There are numerous examples here, serach excel. Quote Link to comment Share on other sites More sharing options...
sanju2323 Posted March 15, 2016 Author Share Posted March 15, 2016 BIGAL, Thank you for the suggestion, I know it's possible from using concatenate and if formula, but I want to directly plot circle using vba. I do not want any extra column. sanju Quote Link to comment Share on other sites More sharing options...
BIGAL Posted March 16, 2016 Share Posted March 16, 2016 Thats the easy way. Ok get a copy of getexel.lsp this is a good example of how to do Autocad excel, you can read and write cells then do what you want you should be able to convert to VBA but why bother, check the samples. Quote Link to comment Share on other sites More sharing options...
sanju2323 Posted March 17, 2016 Author Share Posted March 17, 2016 BIGAL, Thank you very much. sanju Quote Link to comment Share on other sites More sharing options...
BIGAL Posted March 17, 2016 Share Posted March 17, 2016 A second way maybe easier export as a CSV and just read line by line use a IF or Cond to check the "A" cloumn code and use the x&y co-ords pretty easy. In lisp or vba. (cond ((= type "TP")(do_circle)) ((= type "CP")(do_point)) ((= type "FE")(do_INS_FE)) ) Quote Link to comment Share on other sites More sharing options...
sanju2323 Posted March 18, 2016 Author Share Posted March 18, 2016 BIGAL, yes this code is very useful, Thank so much sanju 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.