Hi There,
I am new to the forum and I have tried to look for what I am trying to do. Basically I have a spreadsheet of OLE structures with easting, northing and a designated name this is typically in the format, B85+05
I have automated the spreadsheet to create a string line with each structure's easting and northing, I then
008,3=p001,5=319167.133,6=5813105.918,7=0008,3=p001,5=319226.606,6=5813050.559,7=0008,3=p001,5=319211.174,6=5813065.997,7=0
typical input files (1200 points)
Then as the characters I need on plan are numbers or an element that can be taken by MX due to either type or length restrictions I thought I would then automate draw with string label and then following text for the 1200 points.
The code is typically;
Draw,DES OLE LABELS 801,OVER,2=FREE 850,p001 001,PublicStyles\MfW Text Strings.pss 999 Display, DRAW,DES OLE LABELS 801,OVER,2=FREE 851 859,p001,2=D000,7=0,10=-90,6=3,9=3 001, &-1& B85+05 999 DISPLAY, 999 DRAW,DES OLE LABELS 801,OVER,2=FREE 851 859,p001,2=D000,7=0,10=-90,6=4,9=4 001, &-1& B82+36 999 DISPLAY, 999 DRAW,DES OLE LABELS 801,OVER,2=FREE 851 859,p001,2=D000,7=0,10=-90,6=5,9=5 001, &-1& B83+07 999 DISPLAY,
This continues until the last point. However the line is created but the text is not. I tries this manually for a couple of points and hence the code, however manually doing this for the next 1200 points is quite time consuming. Can anyone assist please?
I'd just like to mention I am not sure how common this is but using MX and Excel has saved me loads of time over the last couple of years to the point where I think its the fastest method to track design changes, do designs for export to plan, long section, cross section and 3D Max.
Mark
Answer Verified By: Robertsm