?

How can i copy inlineshpaes including shapes over it to excel using vba?

Posted on 2017-12-07
8
Low Priority
?
25 Views
Last Modified: 2017-12-10
I'm trying to copy inlineshapes(picture), that picture have shapes over it, using vba to excel.
How can i do it.
0
Comment
Question by:Aj Pdl
  • 4
  • 3
8 Comments
 
LVL 54

Expert Comment

by:Rgonzo1971
ID: 42395231
Hi,

Could you send a dummy?

Regards
0
 

Author Comment

by:Aj Pdl
ID: 42395237
Like this inline picture are many in my documents
I'm trying to convert to Ms Word to Ms excel
0
 
LVL 54

Expert Comment

by:Rgonzo1971
ID: 42395238
No  it's just one shape
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:Aj Pdl
ID: 42395245
I'm sorry, I'm newbie.
If I use Word.Shape to it, the red line is not getting.
Thanks.
0
 
LVL 54

Expert Comment

by:Rgonzo1971
ID: 42395250
Sorry can't help further
0
 

Author Comment

by:Aj Pdl
ID: 42395278
Here  is what i get when i try to count.picWithShape.png
0
 
LVL 54

Expert Comment

by:Rgonzo1971
ID: 42395293
a dummy example?
0
 
LVL 10

Expert Comment

by:Neil Fleming
ID: 42396775
I think you may need to convert the inline shapes to regular "shapes" before you copy them.

for instance:

dim shI as InlineShape, sh as Shape
If Selection.InlineShapes.Count > 0 Then
    Set shI = Selection.InlineShapes(1)
    Set sh = shI.ConvertToShape
    sh.LockAnchor = True
    End If

Open in new window

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Join & Write a Comment

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question