Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know if an external link is working
Hi!
I use VBA to update the information of a workbook into an other. I would like to copy and paste the formula regarding to : A) It is an external link. B) The link is valid (can I test it without displaying a pop-up box which ask to select a new file?) C) The value of the link is equal to the value of the cell (Could differ if the link was not updated in the other workbook.) So, the formulas should be copy only if A, B and C is True. If not, I would like to copy only the value of the cell. Is there a way to achieve that? Thanks a lot ;) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External link lag | Excel Worksheet Functions | |||
How to Change External Link to Internal Link | Excel Programming | |||
External link | Excel Worksheet Functions | |||
Bad External Link | Excel Programming |