Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
upadting question
Is there a code/macro that will enable the user to update all the links to
external workbooks? To bypass the data tab updating and making the changes, saving, closing,and reopening everytime u change the criteria for the formula's. Hoping to be able to save then it will update then. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
upadting question
Try :
ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks HTH Daniel Is there a code/macro that will enable the user to update all the links to external workbooks? To bypass the data tab updating and making the changes, saving, closing,and reopening everytime u change the criteria for the formula's. Hoping to be able to save then it will update then. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
upadting question
Ok I think I entered it in right but it gives me a compile error: Invalid
outside procedure. "Daniel.C" wrote: Try : ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks HTH Daniel Is there a code/macro that will enable the user to update all the links to external workbooks? To bypass the data tab updating and making the changes, saving, closing,and reopening everytime u change the criteria for the formula's. Hoping to be able to save then it will update then. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
upadting question
I tested it with XL2003, XL2007. Which version do you own ?
Can you try : ActiveWorkbook.UpdateLink ActiveWorkbook.LinkSources or : For Each lk In ActiveWorkbook.LinkSources ActiveWorkbook.UpdateLink lk Next lk Daniel Ok I think I entered it in right but it gives me a compile error: Invalid outside procedure. "Daniel.C" wrote: Try : ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks HTH Daniel Is there a code/macro that will enable the user to update all the links to external workbooks? To bypass the data tab updating and making the changes, saving, closing,and reopening everytime u change the criteria for the formula's. Hoping to be able to save then it will update then. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
question. | New Users to Excel | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Question for Peo | Excel Worksheet Functions |