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.
Dim strFileName As String
.FileName = ""
strFileName = frmAssessment.dlgImage.FileName
Now how can I change the name of the file. Any other ideas.