I have a Excel report which as a report populated from a ADO VBA code
in a VBA subroutine which is driven from a button on the Excel
workbook which the user presses to refresh.

Also, I have some pivot reports on this workbook which is refreshed
from a VBA subroutine called from a Excel button.

Our users want this report to be refreshed in batch meaning they want
the report to be refreshed overnight and saved on the network share
that they can lookup the next morning without refreshing.

I am wondering if the workbook is called TestReport.xls and it as a
subroutine called RefreshAllReports please advise how to call this
Subroutine - RefreshAllReports in the Excel workbook - TestReport.XLS
from a VBScript from the operating system.

Please advise how I can implement this kind of scenario appreciate if
you can share the code to call a subroutine in a Excel workbook from a
VBScript.

Thanks
Karen