Paste Special -- Link -- Event raised?

[new.microsoft.com]

I'm trying to detect when data is linked into a worksheet from the
clipboard. The document I'm copying from is a managed document from a third
party document management system and is stored in a temporary location on
the client machine. When the source document is closed, it is removed from
the temp location by the document management system, breaking the link in
the target document. I've been trying to detect when the link is inserted
in order to change it to a synchronized cache location maintained by me. The
problem is that I'm unable to find an event in the Excel object model that
allows me to detect when a link has occurred. I've tried handling the Sheet
Changed event from multiple levels( App, Workbook, and Doc), but the event
only ever fires on a normal paste, and not on a linking paste. This is very
counter-intuitive.

Is there an event in Excel that would fire upon linking?

P.S. I'm using VS.NET 2003, C#, and Office 2003, but this must work in
2000<.



Thanks,

CMD

 

[c duden]

Looks like I screwed up my settings when I posted this so it says it is from
"new.microsoft.com". Sorry about that, I have fixed it.

 

[Wei-Dong Xu [MSFT]]

Hi duden,

I will reply you at the same issue located in
"microsoft.public.office.developer.automation".

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wei-Dong Xu [MSFT]]

Hi duden,

I am sorry for my typing mistake. I will reply you at the same issue in:
microsoft.public.office.developer.com.add_ins

Please feel free to let me know if you have any further questions.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[c duden]

Had my hopes up for a response Wei-Dong
Is there a solution for this?

While you are at it, is there any reason that you can think of that when I
open a document that has extended (custom) properties and view them from
file\document properties and they show up but when I try to retrieve them
programmatically all but one are returned? The property exists in the
collection but it returns an empty string when I get it's value. This
particular property is a URL type string.

Thanks,
C DUDEN

 

[Wei-Dong Xu [MSFT]]

Hi Duden,

Thank you for replying!

For the first question, when a link is inserted into Excel workbook, so far
as I know, there is no such one event for us to catch it. I¡¯d suggest you
may need to monitor the clipboard and watch the event of it. However, you
will need to use win32 clipboard api for this scenario. The ¡°Clipboard
Topics¡± from MSDN web site will introduce some helpful information for
you.
Clipboard Topics
http://msdn.microsoft.com/library/en-us/vccore/html/_core_clipboard_topics.a
sp?frame=true

For the second extended properties question. it will be appreciated you can
post the sample code here or one demo word doc. I will test them for you.

Please feel free to let me know if you have any further questions. I am
standing by to be of assistance.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.