Modify a excel link

[michdenis]

Hi everyone,

I know we may use this method to modify a excel link :

ActiveWorkbook.ChangeLink Name:=OldName, NewName:=NewLinkName, Type:=xlExcelLinks

in vba, Is there a way to integrate the name of the sheet when we modify a link ?.

OldLink =[workbook1.xls]Sheet1!$A$1
NewLink = [NewWorkbook.xls]Sheet5!$A$1

Thank in advance for your time and efforts.


Salutations.

 

[Jim Rech]

Is there a way to integrate the name of the sheet when we modify a link

Find and Replace could do it. I.e., the range Replace method.

--
Jim
| Hi everyone,
|
| I know we may use this method to modify a excel link :
|
| ActiveWorkbook.ChangeLink Name:=OldName, NewName:=NewLinkName,
Type:=xlExcelLinks
|
| in vba, Is there a way to integrate the name of the sheet when we modify a
link ?.
|
| OldLink =[workbook1.xls]Sheet1!$A$1
| NewLink = [NewWorkbook.xls]Sheet5!$A$1
|
| Thank in advance for your time and efforts.
|
|
| Salutations.
|
|

 

[michdenis]

Thank Jim for your suggestion.


Salutations.




Find and Replace could do it. I.e., the range Replace method.

--
Jim
| Hi everyone,
|
| I know we may use this method to modify a excel link :
|
| ActiveWorkbook.ChangeLink Name:=OldName, NewName:=NewLinkName,
Type:=xlExcelLinks
|
| in vba, Is there a way to integrate the name of the sheet when we modify a
link ?.
|
| OldLink =[workbook1.xls]Sheet1!$A$1
| NewLink = [NewWorkbook.xls]Sheet5!$A$1
|
| Thank in advance for your time and efforts.
|
|
| Salutations.
|
|