VBA command to break links

H

heidi

I have a Word doc with links to Excel. Is there a way
using Word VBA to break the links to Excel?
 
M

Martin Seelhofer

I have a Word doc with links to Excel. Is there a way
using Word VBA to break the links to Excel?
Click to expand...

Yes. E.g:

Selection.InlineShapes(1).LinkFormat.BreakLink

.... which breaks the link for the first selected inlineshape.

Or:

Selection.ShapeRange(1).LinkFormat.BreakLink

.... to break the link to the first selected shape.


Cheers,

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section Breaks 0
Excel --> Word 4
Determine if previous "character" is a section break 3
Adding data to MS Access from csv file 0
Mail Merge Directory Conditional Page Break 0
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Linking data in MS Word into Excel 5
Embed the same Excel multiple times 0

Top