I have this code but it doesn't seem to always work.
Gives error message script is out of range.
Code:Workbooks(variable_wk).SaveAs FileName:= path & newNM & ".xlsx"
is there another code ?
I have this code but it doesn't seem to always work.
Gives error message script is out of range.
Code:Workbooks(variable_wk).SaveAs FileName:= path & newNM & ".xlsx"
is there another code ?
Make sure the sheet variable resolves to a valid sheet name and the path variables resolve to a valid path.