Persistence Between Print Jobs 追蹤
Hi, I am trying to figure out if this is possible.
I have a script that works off of a list in an excel file.
I wanted to know if I can make it so the script will "remember" what was printed last and keep the selection on that point in the item list in print station.
Maybe write an extra line on a secondary column and refer to that for position in the list? Just grasping at straws here.
Here is the current script:
Functions and Subs
dim objConn dim strConn dim rs strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='c:\Database\ingredients.xlsx';Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1;""" Public Function GetNames() Dim strNames Set objConn = CreateObject("ADODB.Connection") objConn.Open strConn Set rs = CreateObject("ADODB.Recordset") Set rs = objConn.Execute("SELECT * FROM [Sheet1$]") strNames = "" rs.MoveFirst() do while NOT rs.EOF strNames = strNames + rs.fields("Ingredients") + vbCrLf rs.MoveNext() loop GetNames = strNames End Function
Value = GetNames()
★ BarTender Hero ★