Hey All,

I am ultimately trying to figure out how to open a .text file with excel, run a macro, overwrite and close the excel sheet.
I have a batch file that copies one file and places it in another location as a .text file. The next step is to open the text file with excel, but I cannot figure out how to run the macro at that point.

I am fairly new to the DOS command language and do not know whether or not I can write vba code in the batch file.

Below is my batch command code. 

COPY f:\a\axys3\users\brandon\test.txt C:\Users\btoney\Desktop\IMRF\test.text /y 
START "" "C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE" /e "C:\Users\btoney\Desktop\IMRF\test.txt"
Any help would be much appreciated.

Thank You,
Brandon