Get Last Record From Column X From Excel File Through Vb Script 关注
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!
2 评论
0

Ian Cummings
版主
评论操作
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
请先登录再写评论。