Board index » vbscript
All times are UTC
set oxl = wscript.createobject("EXCEL.Application") oxl.visible = false
oxl.workbooks.open "c:\temp\hr.xls"
oxl.sheets("add").activate 'Error here: subscript out of range. WHen using small hr.xls it works fine. It crashes for a larger xls.
>set oxl = wscript.createobject("EXCEL.Application") >oxl.visible = false
>oxl.workbooks.open "c:\temp\hr.xls"
>oxl.sheets("add").activate 'Error here: subscript out of >range. WHen using small hr.xls it works fine. It crashes >for a larger xls.
>.
1. "subscript out of range"
2. "Subscript out of range Error"
3. "Subscript out of Range" error message
4. GetObject("","InternetExplorer.Application") fails in Excel VBA
5. CreateObject("Excel","//server"), MsgBox output
6. GetObject("","InternetExplorer.Application") fails in Excel VBA
7. CreateObject("Excel","//server"), MsgBox output
8. Output to excel - "Subscript out of range" error
9. Excel an......Range("name").Value = "whatever"
10. Undo "Range"?
11. HELP with .Bookmarks("variable").Range.InsertFile
12. Selection.Sort Key1:=Range("??")
"subscript out of range" - Excel