Forum Discussion

frank_vanderstr's avatar
frank_vanderstr
Contributor
9 years ago

Excel.ActiveWorkBook.WorkSheets is not a function

I am working with scripts that read in an excel file for input data and verification.   I have had no issue in the past but in one of my read functions I am getting a jscript runtime error of   T...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago
HKosova wrote:

Hi Frank,

 

In JavaScript (unlike JScript), you need to use .Item to access collection items in COM objects.

var xlsheet = excel.ActiveWorkBook.WorkSheets.Item(sheetname);

JavaScript - Specifics of Usage: Accessing Collection Items

Ah, yes... there is that... however, he's using the same code in a different location so I'm thinking this is JScript and not JavaScript... but certainly worth the try...