changing links through macro

[cmefly]

hi,

using vba, how can i find out the filename (path and filename) of the file that is linked to my spreadsheet??? would like to assign it to a variable.....

any ideas?

Marc

 

[cmefly]

bump..

 

[Norie]

Marc

What version of Excel are you using?

In the most recent versions Application.FileSearch isn't supported.

I'm not sure it would've done what you want anyway.

Mind you I'm not 100% sure what that it is you want to do.

In what way is the file you want to find out about 'linked' to your file?

 

[cmefly]

hi nori,

i've got a worksheet that does a bunch of calculations. It is linked to a customer's file.
I have many customers....lol

so i just want a macro that goes through each file in a specific folder and updates the calculation worksheet and saves it as say "calculation_customer_soandso.xls"...etc...

i'm trying to change the links in a macro but i'm unable to find a way to get the name of the file that is currently linked to the worksheet....if i had that, then i could use


ThisWorkbook.ChangeLink Name:=OldLink, NewName:=NewLink, Type:=xlExcelLinks


where oldlink and newlink are variables....

makes sense?

 

[cmefly]

i'm using ms excel 2003.

 

[Norie]

Oops, my apologies - I got the thread mixed up with another one that was about Application.FileSearch.

Think it's time to visit the opticians.

Mind you I'm still not sure what you want to do.

Do you want to go through each customer file and take data from it, do some calculations and then save the calculations for that customer in another file?

Anywhere close?