Category Archives: vb

Count rows in excel vb

problem: we want to count number of rows in excel with VB solution: I create the sub function to count the number of rows depend on where do you want to start! Sub countRows() RowCount = 0 RowNext = 22 … Continue reading

Posted in vb | Tagged , , , | Leave a comment

File in use Vb

just found nice code in internet, and i use it in one of my project. works great! it will return the last user that open the file Function LastUser(strPath As String) As String ‘// Code by Helen from http://www.xtremevbtalk.com/index.php?s= ‘// … Continue reading

Posted in vb | Tagged , , | Leave a comment