Paste Special as %PRODUCT Entities in vba ?

[bjod]

Hello.

I'm trying to automate with vba the insertion of excel spread-sheet cells into an autocad drawing using Paste Special as %PRODUCT Entities.

I've been able to make the macro copy the cells in excel, and I'm trying to use the SendKeys statements in autocad to specify the method of pasting.

The problem is the Paste Special dialog box that occurs after SendKeys "Pastespec"
SendKeys "{Enter}"
The SendKeys statements still "talks" to the main Autocad application, and not this dialog box.

How can I send keys to this dialog box, or can anybody suggest a better solution ?

Thanks for taking time
-Bjod

 

[bjod]

I found the solution!!

When using this syntax on each SendKeys statement:

SendKeys"{Enter}",True

It worked just fine! (I forgot to put the True at the end earlier)

-Bjod