March 21, 201312 yr 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?
March 25, 201312 yr 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!
Create an account or sign in to comment