Dear,
I have been bothered by issue of running VB script through PAD. the vb script is used to highlight some cells. The error message says object required: "objWorkbook" on line 4. My colleague in Asia tested the same code and had no error message as return. Could anyone help if there is really any error in my vb script? If there is no error, why objWorkbook is required?
set objExcel = GetObject(,"Excel.Application")
set objWorkbook =objExcel.ActiveWorkbook
objExcel.Application.Visible = True
set objWorksheet = objWorkbook.Worksheets("Sheet1") '' error message refers to this line
objWorksheet.Cells("%LoopIndex%", 18).interior.color = 4