objSheet_2.Cells(i, j) is not working
Here is my code for reading the values from a spreadsheet, the values are correctly trimmed however getting "unknown error" when running the script.
START_R = Trim(objSheet_2.Cells(1, 15).Value)
END_R = Trim(objSheet_2.Cells(2, 15).Value)
CFG_C = Trim(objSheet_2.Cells(1, 17).Value)
MsgBox "START_R: " & START_R
MsgBox "END_R: " & END_R
MsgBox "CFG_C: " & CFG_C
''' MsgBoxs return with correct value.
j = CFG_C
MsgBox "J = " & j
''' j also return with correct value
For i = START_R To END_R
COMMAND_FILE = objSheet_2.Cells(i, j).Value
'''Getting "Unknown runtime error" for above line
'''If I hard code j to a number then above line is working so seems "j = CFG_C" was not treating it as an number.
Which Vandyke product and version are you using? What Operating System are you running on?
To get a better idea of what is happening would it be possible for you to provide the full script and a sheet of sample data?
Please redact any sensitive data from both. If you prefer to email it directly to me please send an email to Support@VanDyke.com with "Attn: Eric Forum post 12766" in the subject line.
|Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)|
|Display Modes||Rate This Thread|