Text Script - Copy and Paste from EXCEL Not Working

[jeremy.herman90]

Hello,

I have a spreadsheet with the following formula:

=CONCATENATE("TEXT ","J ","MC ",H1," 5"," 0"," TEXT")

This gives: TEXT J MC 384895.42,409157.73 5 0 TEXT

When I copy and paste the above into the AutoCAD command line, it gets me all the way to the rotation angle specified as 0, but still is waiting for keyboard entry of the text. I want it to input "TEXT" as well, but it isn't.

When I put the same command in a script file and upload as a script, it works. Any ideas?

[fatal.error · Accepted solution]

Have you tried this?

(command "text" "J" "MC" "384895.42,409157.73" 5 0 "TEXT")

[jeremy.herman90]

Hi, thanks for your reponse. It does not appear to have worked, see screenshot:

[fatal.error]

Your "MN" justify is not a valid option, at least in my acad:

Please try MC as the code above.

[pendean]

Fix your typo

[tramber]

Our friend gave you some lisp....

You need to simulate one more space or ;

(look, the "_" stand for a space)

TEXT J MC 384895.42,409157.73 5 0 "MYTEXT"__

End

TEXT J MC 384895.42,409157.73 5 0 "MYTEXT"_

TEXT J MC 384895.42,409157.73 5 0 "MYTEXT"_

End

A double space is missing or a single one if you enter Return between two lines in a scr file...

[jeremy.herman90]

Nice spot, I tried (with fix) but still did not work:

[jeremy.herman90]

Apologies - it did in fact work. Just already had something in the same location from previous tries so was generating error. Many thanks!

[jeremy.herman90]

Thank you for this. I would like to get this solution to work as well, as it lends itself to better spreadsheeting. I tried this:

EXCEL formula: =CONCATENATE("TEXT ","J ","MC ",H1," 5"," 0"," TEXT__")

Which gives: TEXT J MC 384895.42,409157.73 5 0 TEXT__

When I copy and paste the above directly from the EXCEL spreadsheet, I get the same probem as originally. Leaves me wanting keyboard input.