Is it possible to switch worksheets within a workbook in a WSH VBScript (referenced by name) and if so, how would I do it?
This will be used in a script that already opens an Excel file. I want to access a worksheets called "Version Control".
The following is how I am opening the workbook:
xlsFile = path & "\xml-sitemap.xls"
Set objExcel = WScript.CreateObject("Excel.Application")
Any help on above is really appreciated.