Error #3200 & Excel interface
Hello,
We currently print labels from Bar Tender Print Station. However, following recent additions to the Excel spreadsheet which it communicates with I'm receiving error messages (#3200) i.e. product code in Column A not being recognised.
When I've tried looking into this, it appears that product codes up to line 300 are okay but anything thereafter is not recognised. I've tried deleting lines as a temporary measure to see if this makes a difference i.e. bring product code up the list but to no avail.
Please can you advise?
Thanks in advance,
Annette
-
Do the codes in the column change from all numeric to those including alpha characters?
I have seen this before with Excel and the ODBC driver which only looks at the first few rows and if they are all numeric it seems to assume all the other rows follow the same pattern and so when one is located that is different the data you see in BarTender is blank. If this is the issue add a new record at the start of the spreadsheet and just make the data in all the fields have alpha characters (I often just use the word Dummy for every field) and that should get round this.
0 -
Hi Peter Thane
Thanks for the feedback. Historically we have printed labels using the same Excel spreadsheet with first column containing alpha and alphanumeric data - no problems. The format of the column is set to 'General'.
I've managed to find a workaround in the interim by copying a different label that talks to the same spreadsheet (and working) but then adding the additional label symbols etc. :)
Not ideal though as I still don't understand the root cause for the error in first place and likely to happen again. We are upgrading to latest version though so hoping to have some training/support on this rather than current version which I've inherited...
If you know of anything else that might be worth a try please do let me know.
Thanks again, Annette.
0
Please sign in to leave a comment.
Comments
2 comments