×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Paste Special as %PRODUCT Entities in vba ?

Paste Special as %PRODUCT Entities in vba ?

Paste Special as %PRODUCT Entities in vba ?

(OP)
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

RE: Paste Special as %PRODUCT Entities in vba ?

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources