changing the filename in a Link

B

Ben

Hi,

i have tryed but failed in writing a macro that would change the filename in
a link. I want my users to enter the file name in a cell on one sheet and
then press a button to change the filename in all links in the workbook.

can any one help me?

THX
 
D

Don Guillett

Sub ChangeLinks()
ActiveWorkbook.ChangeLink Name:="menu.xls", _
NewName:="wiebe.xls", Type:=xlExcelLinks
End Sub
or
NewName:=range("a1").value, Type:=xlExcelLinks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems getting this macro to work 23
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Getting sheet name and info from cell 3
Sheet Names and Auto-calculation 2
Saving a workbook with a makro 2
[cell value from filename] 1
How do I display the filename and path in a cell? 8
Increment a filename 4

Top