kyddrivers
Board Regular
- Joined
- Mar 22, 2013
- Messages
- 64
- Office Version
- 365
- Platform
- Windows
We are using a script to open all files in a folder, breaks links and save the file into a new location. There are over 50 files in the folder that the script works on perfectly. We have about 10 files that are causing heartburn.
The vba returns an error on this section of code:
When we hit end or debug on the VBA popup and look at the file the links show broken in the file.
What can be causing this?
We don't see any sheets being protected.
Some paths and link names are long, I believe the longest is about 175 characters. Are we exceeding the string variable?
Any suggestions or ideas are appreciated!
The vba returns an error on this section of code:
VBA Code:
For Each currentLink In linkSources
currentWorkbook.BreakLink currentLink, xlLinkTypeExcelLinks
Next currentLink
When we hit end or debug on the VBA popup and look at the file the links show broken in the file.
What can be causing this?
We don't see any sheets being protected.
Some paths and link names are long, I believe the longest is about 175 characters. Are we exceeding the string variable?
Any suggestions or ideas are appreciated!