Run vba script without opening macro file

Hello guys,
I hope you are all fine.
I am a totally vba newbie with little enquiries.
Could i launch my vba script without the need of opening two of my files simultaneously(a macro file holding the code, and a file named "o" where columns are extracted). Since if i don't open both files i would receive a message (error 9: subscript out of range)
Also, in case the workbooks that are generated had already exist, i dont want to receive a message stating to replace it? i prefer to replace it right away with the new one without notice...
I am thankful for any kind amendment to my below code, or any advice.
God bless you

Please Login or Register  to view this content.

- 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.