PC Review


Reply
Thread Tools Rate Thread

Break link using Macro

 
 
=?Utf-8?B?bWF0ZWxvdA==?=
Guest
Posts: n/a
 
      15th Apr 2007
I have about ~50 graphs that have to manually break the links before I email
out. I would like to write a macro that will allow me to automate that
process. Looking at the help topics, this only flag I found was
automatically/manually update the links. Nothing on the break link. Has
anyone done such thing?

Thanks
Matelot
 
Reply With Quote
 
 
 
 
Shyam Pillai
Guest
Posts: n/a
 
      15th Apr 2007
Have you tried this one?
Break OLE links programmatically
http://skp.mvps.org/ppt00047.htm


--
Regards,
Shyam Pillai

Image Importer Wizard
http://skp.mvps.org/iiw.htm


"matelot" <(E-Mail Removed)> wrote in message
news:274D1FC3-5673-4D2D-B30A-(E-Mail Removed)...
>I have about ~50 graphs that have to manually break the links before I
>email
> out. I would like to write a macro that will allow me to automate that
> process. Looking at the help topics, this only flag I found was
> automatically/manually update the links. Nothing on the break link. Has
> anyone done such thing?
>
> Thanks
> Matelot


 
Reply With Quote
 
=?Utf-8?B?bWF0ZWxvdA==?=
Guest
Posts: n/a
 
      15th Apr 2007
Perfect! That's exactly what I need. Thanks.

"Shyam Pillai" wrote:

> Have you tried this one?
> Break OLE links programmatically
> http://skp.mvps.org/ppt00047.htm
>
>
> --
> Regards,
> Shyam Pillai
>
> Image Importer Wizard
> http://skp.mvps.org/iiw.htm
>
>
> "matelot" <(E-Mail Removed)> wrote in message
> news:274D1FC3-5673-4D2D-B30A-(E-Mail Removed)...
> >I have about ~50 graphs that have to manually break the links before I
> >email
> > out. I would like to write a macro that will allow me to automate that
> > process. Looking at the help topics, this only flag I found was
> > automatically/manually update the links. Nothing on the break link. Has
> > anyone done such thing?
> >
> > Thanks
> > Matelot

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
A macro that will break a link to another workbood Michael Lanier Microsoft Excel Programming 2 29th Jun 2009 03:30 PM
Break a link between workbooks when there is no "break" option FruitNLoops Microsoft Excel Misc 2 31st Jan 2009 05:16 AM
Unable ot Break link for Macro with no source =?Utf-8?B?bmF0ZV9s?= Microsoft Excel Misc 1 10th Dec 2004 12:42 AM
How to break link if "Break Link" is grayed out? =?Utf-8?B?Vko3Nzc3?= Microsoft Excel Misc 3 12th Oct 2004 05:13 PM
Can Not Get Macro to Break with CTRL-BREAK =?Utf-8?B?QnJlYWsgTWU/?= Microsoft Excel Programming 0 8th Sep 2004 03:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:52 AM.