• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

renaming files using vb code

Dim strOldFilename as string
Dim strNewFileName as string

'now just say strNewFileName = P1S1P1

'the original filename is image1.jpj
'this file is stored in C:\database\images\
we want image.jpj to change to p1s1p1.jpg now how would I go about this using vb code. I have used a common dialog box used to select the file. eg image1.jpg.

The location of the filename can be stored in a variable.
eg.
Dim strFileName As String

With frmAssessment.dlgImage
    .FileName = ""
    .ShowOpen
End With

strFileName = frmAssessment.dlgImage.FileName

Now how can I change the name of the file. Any other ideas.
0
Yakeni
Asked:
Yakeni
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Simply:
NAME strOldFileName AS strNewFileName

Cheers
0
 
sharmonCommented:
Public Sub RenameFile(ByVal strFilename As String, _
  ByVal strNewFilename As String)
 
  On Error GoTo PROC_ERR
 
  Name strFilename As strNewFilename
 
PROC_EXIT:
  Exit Sub
 
PROC_ERR:
  MsgBox "Error: " & Err.Number & vbCrLf & _
         "Description: " & Err.Description, vbCritical
  Resume PROC_EXIT
End Sub
0
 
sharmonCommented:
just can seem to hit the button fast enough:)
0
 
YakeniAuthor Commented:
That was simple wasnt it
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now