Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If AskToUpdateLink = False
If I set up:
xlapp.AskToUpdateLinks = False and after that I'm opening a table: Set xlbook = xlapp.Workbooks.Open("Table.xls) Are links updated in this case? Or I need to use as an addition the following thing: xlapp.UpdateLink Name:=xlbook.LinkSources Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If AskToUpdateLink = False
Sorry, for the link update should be
xlbook.UpdateLink Name:=xlbook.LinkSources instead of xlapp.UpdateLink Name:=xlbook.LinkSources -----Original Message----- If I set up: xlapp.AskToUpdateLinks = False and after that I'm opening a table: Set xlbook = xlapp.Workbooks.Open("Table.xls) Are links updated in this case? Or I need to use as an addition the following thing: xlapp.UpdateLink Name:=xlbook.LinkSources Thanks . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If AskToUpdateLink = False
Automatic links are updated without prompt if you set AskToUpdateLinks to
True. -- Regards, Tom Ogilvy "AlexD" wrote in message ... Sorry, for the link update should be xlbook.UpdateLink Name:=xlbook.LinkSources instead of xlapp.UpdateLink Name:=xlbook.LinkSources -----Original Message----- If I set up: xlapp.AskToUpdateLinks = False and after that I'm opening a table: Set xlbook = xlapp.Workbooks.Open("Table.xls) Are links updated in this case? Or I need to use as an addition the following thing: xlapp.UpdateLink Name:=xlbook.LinkSources Thanks . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If AskToUpdateLink = False
Sorry, Tom.
But, when you set up it to True you'll get a prompt asking whether to update the links. If you set up it to False there is no any prompt, which is Ok for me, and it looks like links are updated anyway. But, I'd like to know it for sure. Thanks, Alex -----Original Message----- Automatic links are updated without prompt if you set AskToUpdateLinks to True. -- Regards, Tom Ogilvy "AlexD" wrote in message ... Sorry, for the link update should be xlbook.UpdateLink Name:=xlbook.LinkSources instead of xlapp.UpdateLink Name:=xlbook.LinkSources -----Original Message----- If I set up: xlapp.AskToUpdateLinks = False and after that I'm opening a table: Set xlbook = xlapp.Workbooks.Open("Table.xls) Are links updated in this case? Or I need to use as an addition the following thing: xlapp.UpdateLink Name:=xlbook.LinkSources Thanks . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
If AskToUpdateLink = False
That was a typo - set it to false - uncheck it in Tools=Options=Edit Tab
The links are updated as I correctly stated. -- Regards, Tom Ogilvy "AlexD" wrote in message ... Sorry, Tom. But, when you set up it to True you'll get a prompt asking whether to update the links. If you set up it to False there is no any prompt, which is Ok for me, and it looks like links are updated anyway. But, I'd like to know it for sure. Thanks, Alex -----Original Message----- Automatic links are updated without prompt if you set AskToUpdateLinks to True. -- Regards, Tom Ogilvy "AlexD" wrote in message ... Sorry, for the link update should be xlbook.UpdateLink Name:=xlbook.LinkSources instead of xlapp.UpdateLink Name:=xlbook.LinkSources -----Original Message----- If I set up: xlapp.AskToUpdateLinks = False and after that I'm opening a table: Set xlbook = xlapp.Workbooks.Open("Table.xls) Are links updated in this case? Or I need to use as an addition the following thing: xlapp.UpdateLink Name:=xlbook.LinkSources Thanks . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If AskToUpdateLink = False
Thanks, Tom.
-----Original Message----- That was a typo - set it to false - uncheck it in Tools=Options=Edit Tab The links are updated as I correctly stated. -- Regards, Tom Ogilvy "AlexD" wrote in message ... Sorry, Tom. But, when you set up it to True you'll get a prompt asking whether to update the links. If you set up it to False there is no any prompt, which is Ok for me, and it looks like links are updated anyway. But, I'd like to know it for sure. Thanks, Alex -----Original Message----- Automatic links are updated without prompt if you set AskToUpdateLinks to True. -- Regards, Tom Ogilvy "AlexD" wrote in message ... Sorry, for the link update should be xlbook.UpdateLink Name:=xlbook.LinkSources instead of xlapp.UpdateLink Name:=xlbook.LinkSources -----Original Message----- If I set up: xlapp.AskToUpdateLinks = False and after that I'm opening a table: Set xlbook = xlapp.Workbooks.Open("Table.xls) Are links updated in this case? Or I need to use as an addition the following thing: xlapp.UpdateLink Name:=xlbook.LinkSources Thanks . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do nothing if False! | Excel Worksheet Functions | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
0 instead of false | Excel Discussion (Misc queries) | |||
$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # | Excel Worksheet Functions | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions |