assigning value to a bigtext variable

jks

Hello,

There is only one field in my excel sheet and it contains 10 records. I want to go through a loop and one by one i want to assign record to a bigtext variable.

How can i do that?

PLEASE HELP.

Arhontis

Hi,

If I understand you correctly, you are trying to write some code in Navision to read from an excel worksheet and sequentially read the values of a field and assign its value to a Navision text variable.

Look at the "Import Budget from Excel" report and the "Excel Buffer" table that it is used to get some ideas on reading and using cells from excel.