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

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
.

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
.

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
.



.

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
.



.

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
.



.



.