Hey there,
I do a ton of excel copy and pasting in excel from autocad.
I would like to find a way to write a script to paste a picture from my clipboard, as an Enhanced Metafile, and then have it cropped (dimensions tbd) and then set to a location (Cell B1).
I've been able to paste and crop a normal file, but have been stuck since.
Any hints?
Hello Mortysauce,
I am assuming you have a Mac since your Office version appears as 2016. As far as I know, with a Mac you cannot paste a picture from the clipboard using VBA. However, if you are using PC, you can do this. I won't post the code unless you have a PC and tell me the version of Windows you have since it affects the API code.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I have a PC, and I checked my account and it say I have Microsoft home and business.
Hello Mortysauce,
Here is the version for 32 bit CPU systems. If you have problems compiling this code then you have a 64 bit CPU system and I will have to post the code in a separate post due to the size of the post.
Copy this code into a new VBA Module in your workbook. Let me know if you have any compile issues and we'll go to the next step
.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks