Help with xlupdatelinks

[Mr_K]

I have found a statement to use to update the links I have in my spreadsheet.

Now my problem is to appropriately apply it for the purpose I want it for. xlUpdateLinks is a statement I have found. I want to apply it in a way that will allow me to choose the sequence the spreadsheet should update links.

Any help in this regard is greatly appreciated.

 

[GlennUK]

xlUpdateLinks is a statement I have found.

... there is no such statement ( as far as I know ). Did you mean UpdateLink instead maybe? The Help for that mentions the LinkSources method, which has an example in it's Help which should help you a lot.

 

[Mr_K]

const xlUpdateLinksUserSetting = 1

Is what I meant.

Has any one use this before?

 

[GlennUK]

Mr K,

you have spotted what looks like one of the XlUpdateLinks Enumeration members ... website says:

xlUpdateLinksUserSetting Embedded OLE links are updated according to the user's settings for the specified workbook.

Look at the help for LinkSources, it has an example which should help you a lot.