VB + Excel

[jsilveira]

Hi,

I currently linked cells from different excel workbooks. I was wondering whether anyone knew of vba code that i could use to automatically relink the cells (in the event the path of the workbooks changed), instead of having the user always click the yes button when the workbooks are opened?

any other suggestions are welcomed.

many thanks,
jsilveira

 

[SkipVought]

Hi,

How would the program know that the path of the source workbook has changed? To What?

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]