Ok I need to know how using VB how to open 500 workbooks and break all links to another workbook but leave the rest of the formula. I know how to loop thru all files but not remove the link reference.
=+'[Book1]Sheet1'!A1
needs to be
=Sheet1'!A1
I tried the below but it did not work.
For Each scrFile In scrFolder.Files
strName = scrFile.Name
Workbooks.Open (scrFile)
Cells.Replace What:="[Book1]", Replacement:=""
Activeworkbook.Close (True)
Next scrFile
Any help someone could give would be greatly appreciated cause I do not want to manually do the find and replace method.
=+'[Book1]Sheet1'!A1
needs to be
=Sheet1'!A1
I tried the below but it did not work.
For Each scrFile In scrFolder.Files
strName = scrFile.Name
Workbooks.Open (scrFile)
Cells.Replace What:="[Book1]", Replacement:=""
Activeworkbook.Close (True)
Next scrFile
Any help someone could give would be greatly appreciated cause I do not want to manually do the find and replace method.