Creating table in Excel using VBscript gives Invalid error -
Text after "div class =" itemprop = "text">
I create the following code using the cscript in the VB script Windows 7, generating a sequence of "invalid process call or logic" error Running the table using ListObjects. Set ExcelObject = CreateObject ("Excel.Application") ExcelObject.visible = true ExcelObject.WorkBooks.Add 'a workbook adds an Excel object set to mySheet = ExcelObject.Sheets (1) mySheet .Activate mySheet.ListObjects.Add (xlSrcRange, mySheet.Range ("A1: D10"), xlYes) .name = "mytable"
Comments
Post a Comment