Looking for a Lisp that can change the visibility states of series of blocks from cell value

[ebandian]

Hi Lisp experts, I needed some help regarding my project.

I want to run a specific lisp that can change the visibility state of a block which is stated on a Acad table (soon to be from Datalink).

Explanation:

Column 1 will be the name of the block

Column 2 will be the name of the visibility state to change to.

[paullimapa]

so on your Autocad 2021 at home did you try both VChgTbl4LT.lsp & VChgTbl.lsp ?

[ebandian]

I will try to reinstall my Autocad, hope that will solve the issue. 

[ebandian]

I will try to reinstall my AutoCAD and hopes that it will fix the issue.

[ebandian]

I haven't tried the VChgTbl4LT.lsp at home, 

but the first version of VChgTbl.lsp works on acad table, but the modded code for datalink did not work even on acad table if that make sense.

[paullimapa]

Try downloading the modified VChgTbl.lsp version again from my previous post 

[ebandian]

Both lisp show an error

[ebandian]

This could be the problem on my end,

ACET-STR-FIND is not supported on AutoCAD LT

[paullimapa]

That error is because LT does not support Express Tools. I tried to extract some of the clean text format functions but there are still so many Express Tools functions in that which is preventing LT from running it.

So if your home AutoCAD 2021 does not have Express Tools installed then VChgTbl4LT.lsp version would not work either. But the VChgTbl.lsp version should work on it.

[ebandian]

Got it, Thanks for your help paullimapa!

[ebandian]

Could it be that there is codes/lisp that would work to copy the contents from the datalink table to an acad table, just to bypass the codes not compatible with AutoCAD LT. So after I copy the contents to an acad table, I will use the 1st version of VChgTbl.lsp to that acad table.

[paullimapa]

The additional code the datalink table introduces in each cell looks something like these:

"{\\fAptos Narrow|b0|i0|c0;Block1"

"{\\fAptos Narrow|b0|i0|c0;Circle"

So assuming you don't introduce any more formatting in each cell in Excel then what I decided to do is to simply search for the semicolon ";" character which only occurs once in your example and retrieve the content after that.

I modified both VChgTbl.lsp (that accommodates for both LT & AutoCAD) from my previous post and VChgTbl4LT.lsp (for just LT) from my previous post to make this work for your Excel Datalink Table.

[ebandian]

IT WORKS!!!!
Thank you very much!

Now my work flow be fast! Thanks for the help!

[paullimapa]

once again glad to have helped...cheers!!!