VBS in a DOS batch file

I do not understand VBS but was given VBS code which I have used successfully in a DOS batch file. That success makes me think that maybe I can do it again in another context. I've been given code as a result of saying that I wanted to save an open Excel spread sheet by means of a DOS batch file. The code does not work by itself in the batchfile, and is so dissimilar from the first example which I mentioned, that I can get no clues from the first for applying to the second. Can someone here give me the 'missing links' to make the following code effective in a DOS batchfile ? :

Dim x
set x = getobject(, "Excel.application")
'msgbox x.caption
x.SaveAs "C:\FileLocation\WorkBookName.XLS"
x.Application.Quit
Set x= Nothing

A second suggestion was to 'capture' the macro created for/when saving the spreadsheet. That content is much simpler, but again, I don't know how to make it effective in a DOS batchfile.

Neither of those would be doable in a dos batch file.

The closest that you might be able to get would be to put a macro in the workbook that would print the sheet you want then close excel. Then it would be possible to call the excel file and pass in a command line parameter that caused it to run that macro.

I don't want a sheet printed - I just want to save the opened and edited  excel sheet.

Sorry, that isn't possible in DOS. To do that you would need to use the COM API that Excel exposes and DOS has no way to access that. Why not just write a VBScript and have your batch file call that?

That is precisely what I have done, with much assistance from an Excel forum
and it works. I had many vicissitudes in the excel forum and it seemed maybe I was asking the wrong people - that is when I sought and found this forum. But then my fortunes took a turn for the better, and someone at MrExcel took me through the process step by step. Presto, DONE. Thank you.