serialization write in Excel database Follow

0
Avatar
Rui Morgado

Hi,
Im new with bartender, i have a database of products made in Excel (XLS format) with a field called Serial.

I need that bartender read the field Serial from database and when i print increment the field on database.

Is this possible with excel?

Thank you.

2 comments

0
Avatar
Peter Thane
Comment actions Permalink

Hi Rui,

Someone had asked a very similar thing, but for Access in the Visual Basic forum (https://support.seagullscientific.com/hc/en-us/community/posts/360015763834-Saving-Serial-Data-to-MS-Access-after-printing) 

There is not a simple way to achieve this as BarTender cannot write back out to Excel directly and you would need to use Visual Basic Script functionality to achieve this. Sorry I am not sure what the code would be for this and so you may need to either find someone who can program VB to help you or else trying searching the web for some assistance. 

Pete 

0
Avatar
Peter Thane
Comment actions Permalink

One consideration is the ODBC driver. With Excel only one "person" can access it at a time and BarTender counts as a person in this instance and so I wonder if the ODBC link that reads from the spreadsheet would prevent you writing to at the same time and so you may need to use the Event Controlled Scripting and on Print End or similar.

Please sign in to leave a comment.