WSH VBScript switch workSHEET in already open Excel workBOOK

Takeshi Okada 3516 20 Jun 2013

Hi Expert,
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")
objExcel.Workbooks.open(xlsFile)

Any help on above is really appreciated.

Takeshi Okada

Other

1 Answers

Sumit Kesarwani 20 Jun 2013

Hi Takeshi,

This will do it (amended following Ekkehard.Horner's comment)

Dim ws

Dim wb

xlsFile = path & "\xml-sitemap.xls"

Set objExcel = WScript.CreateObject("Excel.Application")

objExcel.Workbooks.open(xlsFile)

Set wb = objExcel.ActiveWorkbook 'the ActiveWorkbook will refer to the opened workbook

Set ws = wb.Worksheets("Version Control") 'ws is a Worksheet object

forum

WSH VBScript switch workSHEET in already open Excel workBOOK

Can you answer this question?

1 Answers