Getting %s: %s when extracting data
Posted on 2002-05-28
I am running LotusScript code that extracts data from a document and puts in Excel. Problem is it fails when it tries to extract the field names and it pops up with a window with this error: "%s: %s" What does this mean?
Here's a snippet of code below. If I a step through the code, the error pops up at the line where it says, "If x = -1 Then". There's at least 234 fields(items) it is trying to extract..would the no of fields be the problem? Most of the fields have no data. Thanks.
'Get Field Names that will become column headings
x = -1
Forall i In ndocData.Items
If Left(i.Name, 4) = "xml_" Then
x = x + 1
Redim Preserve itemNames(x)
itemNames(x) = i.Name
If x = -1 Then
Msgbox "No data fields found!"