;

Change File Extension


Public Function GetElapsedTime(tStart, tStop) As String
Public Function ChangeFileExt(ByVal aFilename As String, ByVal NewExt As String) As Boolean
Dim p As Long
Dim bp As Long
Dim nFileName As String

On Error Resume Next
   ChangeFileExt = False
   If aFilename = "" Then Exit Function
      p = 0
      Do
        bp = p
        p = InStr(p + 1, aFilename, ".", vbBinaryCompare)
      Loop Until p = 0

      If bp > 0 Then
         nFileName = Left(aFilename, bp - 1)
      Else
         nFileName = aFilename
      End If
     nFileName = nFileName & "." & NewExt
     Err.Clear
     Name aFilename As nFileName

     If Err.Number = 0 Then ChangeFileExt = True
End Function

No comments:

Post a Comment

Post Comments


Do you have any suggestions ? Add comment. Do not spam!

Search By Google

About this blog

Vision and Mission
Assist each company to improve efficiency and effectiveness to achieve the objectives to serve clients in a professional, objective and sustainable and provide the best solutions for businesses in solving problems in the procurement of informatics and technology.

Excellence
With support from experts and experienced professionals and geared towards fulfilling the needs of clients who put quality in a cost competitif. We also work as partners culter tailored to your company's corporate and can also provide an applicable and practical advice for clients.

New

 

WELCOME

Welcome to the Thomas IPT Blog - Thank you being here, and hope you come back often. Please surf here and read more about the world of computers and various articles of the world that I experienced. There are many things about, you'll probably find something interesting.

ABOUT ME

Working as a Management Information System Design And Development Operations Accounting. Specializing in the manufacture of Retail Database Desktop Applications, ERP / MRP, KSP / KSU, Warehouse, etc by using VB, SQL, Access, Crystal Report

NAVIGASI

SOCIAL STUFF

Info