- To read from a file you need to open it, copy what you need and then close it again. All this could be done by macro.
- To avoid messages just use the function Application.DisplayAlerts = False before the line of Saving code and Application.DisplayAlerts = True just after Saving or just before Ending the Sub.