Creating a new Command - Question

[happyunited]

Hi

 

I do alot of datalinking from excel and the way I normally do it is by copying what I need from excel, paste special > paste link > autocad entities. I am trying to make up a button/command so I dont have to kep going trough those steps every time, I can have up to 24 links on one drawing.

 

This is what I have Marco section ; ^C^C_pastespec

 

But this only brings up the paste special box and I still have to click paste link, autocad entities etc.

 

What do I need to add to this so it pastes directly to autocad entities all in one go?

 

Many thanks in advance.

[happyunited]

Someone must know the answer to this?

[dbroada]

I don't understand your question but are you getting dialogue boxes that interupt your macro? Try setting CMDDIA=0 first which will turn off some dialogue boxes and continue with the command line (or macro supplied) text. Some newer commands - find & replace being a good example - do not have a command line equivalent so cannot be used in this manner.

[happyunited]

This might explain things a bit better....

 

These are the couple of steps I take in order to paste in a datalink....

 

EDIT > PASTE SPECIAL > PASTE LINK > AUTOCAD ENTITIES.

 

I want to creat a marco to do all this in one click of a button but the marco that I have created (in my first post) only gets me to this stage ;

 

EDIT>PASTE SPECIAL.

 

I still have to paste link and then hit audocad entities.

 

What do I need to addd to my marco so it does all of this (EDIT > PASTE SPECIAL > PASTE LINK > AUTOCAD ENTITIES) in one go.

 

Hope that explains it better.

[dbroada]

I've not tried anything like that so I'll bow out at this stage. All I can suggest is that you look on the text screen (F2) and see if any commands were echoed there. I suspect it is all dialogue driven and your options are limited within straight AutoCAD. It may be possible in LISP/VBA but I wouldn't know where to start.

[happyunited]

I've not tried anything like that so I'll bow out at this stage. All I can suggest is that you look on the text screen (F2) and see if any commands were echoed there. I suspect it is all dialogue driven and your options are limited within straight AutoCAD. It may be possible in LISP/VBA but I wouldn't know where to start.

 

Thanks for your help.

 

Thats what I did and all I go was _pastespec.