Get Last Record From Column X From Excel File Through Vb Script

Legacy Poster

• September 02, 2015 22:31

Hi folks,

 

in my label i would like to grab the last used record from an excel file using vb script when opening the label.

 

For instance, my excel file has in the first column:

 

products

product1

product2

product3

 

The label should display product3. I need to use vb scripting since i am planning to create another database connection with the same label.

 

I assume product3 in this example should be named as some data source but i got no clue whatsoever how the vbscript should look like. 

 

Any help on this i would greatly appreciate, thanks!

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • September 07, 2015 14:15

  I guess the rs.MoveLast method would be your best bet:  See example from MSDN: https://msdn.microsoft.com/en-us/library/ms676810(v=vs.85).aspx

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • September 07, 2015 21:56

  Thanks Ian for your suggestion 

  0

Please sign in to leave a comment.