How to change Excel Workbook link settings by VBA??

[dannydanny]

Hi,

I have an Excel Workbook A which has links to another Excel Workbook B. Usually I would go to Edit -> Link Settings to find information about the path / location of the source workbook B, but how can I find and/or change this information using VBA??

Thanks for any info in advance,
Danny

 

[PHV]

Have you tried the macro recorder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dannydanny]

Hi,

I tried the macro recorder and had a look at the code, but if I just go to Edit -> settings to look at the external link info, the macro records nothing because I really haven`t executed/issued any commands. I just need the link info......

Anyway, i played around with VBA, its the Application object`s LinkSources method which gives me want I wanted.
I just didn`t know how to use it before, since I was looking for an Application plink info property....

Thanks for your help anyway,
Danny