Skip to Content
0
Jul 01, 2019 at 04:07 AM

Error when running script playback - GUISCRIPT

158 Views

I have a vbs script used to replay scripts that update data from excel spreadsheets into SAP. but when I click playback, I get the following error: '' Unable to write read - only property ".
 So who knows the cause and how to fix it, please help me. thank you
code

Dim objExcelDim objSheet, intRow, i

Dim objExcelDim objSheet, intRow, i

Set objExcel = GetObject(,”Excel.Application”).

Set objSheet = objExcel.ActiveWorkbook.ActiveSheet

For i = 2 to objSheet.UsedRange.Rows.Count

= Trim (CStr (objSheet.Cells (i, 1) .Value)) 'Cột1

COL2 = Trim(CStr(objSheet.Cells(i, 2).Value)) ‘Column2

..................................................................................................................................................

next

nextmsgbox “Process Completed”