Roundpanda
New Member
- Joined
- Jun 15, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have a macro that iterates through an input range and saves a new workbook using SaveCopyAs for each input but I want to know how I can break the links in the new workbooks that it saves down. Here's the current code:
For Each name In inputRange
dvCell.Value = name.Value
Application.ActiveWorkbook.SaveCopyAs _
Filename:=path & file & dvCell.Value & ".xlsm"
Next name
For Each name In inputRange
dvCell.Value = name.Value
Application.ActiveWorkbook.SaveCopyAs _
Filename:=path & file & dvCell.Value & ".xlsm"
Next name