T
Trish Smith
Hi everyone,
I posted last week and Ron de Bruin pointed me to his website for code that
looped thru files in a folder which was just what I needed.
I've just come back to this bit of work now and realised that the original
code allows you to select the source of the old link and then of the new
link.
I would like to automate this and the old link will be the same for all 40
or so of the wkbks in the folder. The new link will be the active workbook.
ActiveWorkbook.ChangeLink Name:="C:\testing\Source.xls", _
newname:=strnewlink, _
Type:=xlLinkTypeExcelLinks
How do I write it so that newname is the active workbook each time?
Many thanks
I posted last week and Ron de Bruin pointed me to his website for code that
looped thru files in a folder which was just what I needed.
I've just come back to this bit of work now and realised that the original
code allows you to select the source of the old link and then of the new
link.
I would like to automate this and the old link will be the same for all 40
or so of the wkbks in the folder. The new link will be the active workbook.
ActiveWorkbook.ChangeLink Name:="C:\testing\Source.xls", _
newname:=strnewlink, _
Type:=xlLinkTypeExcelLinks
How do I write it so that newname is the active workbook each time?
Many thanks