I am trying to run a simple script to do a search on our FM database based on the values in a column in an excel spreadsheet using Scribe.

The document loads without any error, but when I go into my loop to parse the values by the row I get this error from my error feedback scripting:

Reading values is not supported for the file Shipments!A2

For the record I am trying to read a value from a sheet entitled Shipments, first column skipping column label and on down the column. This error plays on each iteration of my loop (A2 updates accordingly, A3, etc).

I cannot see any error in my syntax as being a problem...it's pretty straightforward. What am I missing here?

Here is the top half of my loop to show what I'm trying to do:

Set Variable [$i; Value:1]

Loop

Set Variable [$i; Value:$i + 1]

Set Variable [$readRow; Value:ScribeDocReadValue ( "Shipments!A" & $i )]

If [not $readRow]

Show Custom Dialog ["An Error Occurred"; ScribeLastError]

End If

Exit Loop If [isEmpty ($readRow)]

...do stuff...

End Loop

think I found the problem, the excel file was of type .xls which I saved as .xlsx - this appears to work now...