topic Re: Text Script - Copy and Paste from EXCEL Not Working in AutoCAD Forum

Text Script - Copy and Paste from EXCEL Not Working

jeremy.herman90 — Mon, 07 Mar 2022 12:00:05 GMT

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?

Re: Text Script - Copy and Paste from EXCEL Not Working

fatal.error — Mon, 07 Mar 2022 14:28:57 GMT

Have you tried this?

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

Re: Text Script - Copy and Paste from EXCEL Not Working

jeremy.herman90 — Mon, 07 Mar 2022 14:32:32 GMT

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

Re: Text Script - Copy and Paste from EXCEL Not Working

fatal.error — Mon, 07 Mar 2022 14:43:00 GMT

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

Please try MC as the code above.

Re: Text Script - Copy and Paste from EXCEL Not Working

pendean — Mon, 07 Mar 2022 14:46:36 GMT

Fix your typo

Re: Text Script - Copy and Paste from EXCEL Not Working

tramber — Mon, 07 Mar 2022 14:47:47 GMT

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"_

End

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

Re: Text Script - Copy and Paste from EXCEL Not Working

jeremy.herman90 — Mon, 07 Mar 2022 14:47:47 GMT

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

Re: Text Script - Copy and Paste from EXCEL Not Working

jeremy.herman90 — Mon, 07 Mar 2022 14:51:19 GMT

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

Re: Text Script - Copy and Paste from EXCEL Not Working

jeremy.herman90 — Mon, 07 Mar 2022 14:58:18 GMT

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.