Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel event to determine if link has been added to the document
Hi All,
I am writing a plug-in for excel in Visual Basic. Is there a event that says that a link has been added in the excel document that I can trap. Thanks, Vishal |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel event to determine if link has been added to the document
Not specifically. The change event would fire if a cell was edited and you
could check that cell to see if the formula was a link. -- Regards, Tom Ogilvy "Vishal" wrote: Hi All, I am writing a plug-in for excel in Visual Basic. Is there a event that says that a link has been added in the excel document that I can trap. Thanks, Vishal |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel event to determine if link has been added to the documen
Hi Tom,
Thats correct. I used the worksheet and workbook events to achieve the same effect. Also finding if the formula is a link involves parsing the formula (Can be done using linksource)? Also if a link is deleted then how can I find that link is deleted (What the previous value is and what the current value is)? Best Regards, Vishal "Tom Ogilvy" wrote: Not specifically. The change event would fire if a cell was edited and you could check that cell to see if the formula was a link. -- Regards, Tom Ogilvy "Vishal" wrote: Hi All, I am writing a plug-in for excel in Visual Basic. Is there a event that says that a link has been added in the excel document that I can trap. Thanks, Vishal |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel event to determine if link has been added to the documen
Linksources will give you all the links, so you can maintain a list and
identify if there was an addition or deletion. I can't think of any other reason a formula would contain a '[' (if it doesn't have a double quote) so if Target.HasFormula and instr(1,target.formula,"[",vbTextcompare) and _ instr(1,target.formula,chr(34),vbTextcompare) = 0 then ' link here -- Regards, Tom Ogilvy "Vishal" wrote: Hi Tom, Thats correct. I used the worksheet and workbook events to achieve the same effect. Also finding if the formula is a link involves parsing the formula (Can be done using linksource)? Also if a link is deleted then how can I find that link is deleted (What the previous value is and what the current value is)? Best Regards, Vishal "Tom Ogilvy" wrote: Not specifically. The change event would fire if a cell was edited and you could check that cell to see if the formula was a link. -- Regards, Tom Ogilvy "Vishal" wrote: Hi All, I am writing a plug-in for excel in Visual Basic. Is there a event that says that a link has been added in the excel document that I can trap. Thanks, Vishal |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel event to determine if link has been added to the documen
Thanks a lot Tom. This was very helpful.
Best Regards, Vishal "Tom Ogilvy" wrote: Linksources will give you all the links, so you can maintain a list and identify if there was an addition or deletion. I can't think of any other reason a formula would contain a '[' (if it doesn't have a double quote) so if Target.HasFormula and instr(1,target.formula,"[",vbTextcompare) and _ instr(1,target.formula,chr(34),vbTextcompare) = 0 then ' link here -- Regards, Tom Ogilvy "Vishal" wrote: Hi Tom, Thats correct. I used the worksheet and workbook events to achieve the same effect. Also finding if the formula is a link involves parsing the formula (Can be done using linksource)? Also if a link is deleted then how can I find that link is deleted (What the previous value is and what the current value is)? Best Regards, Vishal "Tom Ogilvy" wrote: Not specifically. The change event would fire if a cell was edited and you could check that cell to see if the formula was a link. -- Regards, Tom Ogilvy "Vishal" wrote: Hi All, I am writing a plug-in for excel in Visual Basic. Is there a event that says that a link has been added in the excel document that I can trap. Thanks, Vishal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
How to get the leading zero's added in a document | Excel Worksheet Functions | |||
add event to controls added in runtime | Excel Programming | |||
Event procedures for controls added with CreateEventProc | Excel Programming | |||
Event procedures for controls added with CreateEventProc | Excel Programming |