Thanks to Steven-g over at Cadtutuor
It should be split into lines like this
Layout new Layout3
ctab
layout3
Mview 50,50 800,530 mspace zoom c 330,400
scale
'Layout3' in the code is a literal name and Autocad is expecting a text item so you have to use a linefeed to mark the end of the 'text'.
This does mean spreading the Excel concatenate formulas over multiple rows. Which makes a lot more work when you are bringing the data into Excel, because you have to have 4 rows of formulas for each row of data. One way around that is to split the concatenate formulas into different columns on a row and then use VBA programing to write out the script into a .scr file and put each column onto a newline.
So copy to say column F in excel, column A B C D are the x y values of the boxes so can do the calcs adding spacing, F contains say Layoutname. The scale should be a value.
