Getting random values from EXCEL
I have random values generated in an excel file.
I want to make each subsequent printed page enlighten the values in the file and retrieve new values for printing.
Can this be done in the 2021 program?
Paramets EXCEl (=LOS()*(0,09-0,02)+0,02)
Thank you for your help
Thank you for reaching out to us on the Community Forums.
If I understand correctly, you want to generate the random value in your Excel database, have BarTender read it and mark it when used, and then use a new value for the next printed item? If it's something else, can you provide further information or clarification on what it is you are trying to achieve?
You may try to use Document Actions (File > BarTender Document Options) for example with an 'Update Database Record Action' which requires the Automation Edition or higher:
Alternatively, this should be possible with Visual Basic Scripting. This would be outside the scope of our technical support however we do have a Professional Services team that may be able to assist with this for a cost.
Another option you could use is extend your routine in Excel to, once you have validated the number is correct etc in the spreadsheet, output the random number in a Text file and configure an Integration (via the Integration Builder application) to trigger off this file and open the BarTender label, print the number and then delete the file afterwards.
Using this method would mean BarTender would not have to access the spreadsheet itself and so you get round the read only/sharing issue where more than one "person" tries to open the same Excel document.0
Thank you for the hint.
I think it can be done.
I will select cells in Excel that are to be downloaded to the table in Bartender and, as I wrote, refresh each subsequent printout.
Such cells will be marked in the file.
Tried fast and got a bug. But I have to put it calmly in Action
Assuming the connection is configured correctly in the label, is the Excel document closed when you try to print or else you could get error messages similar to this?0
The document is closed. Maybe the problem is that when I update each record, it does not connect to the database only in the table place. It is supposed to retrieve the values of randomly selected numbers from the file, except for the first line.0
Iniciar sesión para dejar un comentario.