It sounds like you're wanting to take my VBScript
and use it in VBA, I already do that.
Perhaps it would be easier to just give you the VBA !!

Do you have their "home" server mapped to a drive letter?

Are you talking about copying some "other" file rather than the Excel file
you're running the VBA code in?

Let me know what you're currently doing with the bat file and perhaps I already
have something that is doing something similar that I can modify to do what
you're looking for.