macro per importare tabella excel in autocad

[Sandecker]

Hello everyone,

I'd have a little trouble to solve. My goal would be to create a button inside a toolbar in the autocad environment that glues me on the drawing a table of excels (of which I know the path and the name).

the action would be a trivial copy and paste from excel to autocad, but I would avoid going all the time to open the excel sheet with the table I want to paste in autocad (the destination of which is not always easily accessible).

the excel sheet name varies from time to time depending on the dwg file name. the macro then should take into account this when looking for the excel sheet in the directory.

Is there a simple way to do this?

I hope I've explained well,
thank you very much for the answers,

Hi.

 

[rpor66]

I can't find a method to do pastaspecial in autocad via vba.
if someone has info you make it feel.

Thank you.