Modify a excel link
 

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.

Modify a excel link
 

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
"michdenis" wrote in message
...
| 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.
|
|

Modify a excel link
 

Thank Jim for your suggestion.


Salutations.



"Jim Rech" a écrit dans le message de news: ...
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
"michdenis" wrote in message
...
| 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.
|
|