hi all
iwant extract only three digits (#.#) from thisworkbook.
before three digits search criteria is " v"
hi all
iwant extract only three digits (#.#) from thisworkbook.
before three digits search criteria is " v"
Function GetVersion() As Double Dim sFileName As String, iStartPos As Integer sFileName = ThisWorkbook.Name iStartPos = InStr(1, sFileName, " v") GetVersion = CDbl(Mid(sFileName, iStartPos + 2, 3)) End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks