Scribe: Trying to Read from Excel using Dynamic Variables

[Craig Wall]

I am struggling w/this. It seems like it should work, but doesn't.

 

I can pull data from Excel with an literal call:

ScribeDocReadValue( "B5" )

That kind of thing is working just fine.

 

But I am trying to use variables that designate the target cel in Excel...and increment in a loop, thus scraping data with some precision.

 

For example I have a variable: $$PO_Number_Cel  that returns this literal text, "C4"

I then use that resulting variable in this fashion

ScribeDocReadValue(( """ & $$PO_Number_Cel & """ ))

 

But all I get is an error in the set field that utilizes this technique, despite my tweaks and tests.

 

Can anyone savy with this that can provide a little guidance?

[Joe Pampalon]

If $$PO_Number_Cel returns a text literal such as "C4" then you shouldn't need to surround it in quotes when using ScribeDocReadValue. 

 

The correct call with your setup should just be: 

ScribeDocReadValue( $$PO_Number_Cel )

 

Let me know if this helps!