Excel 2007 create a copy of a file using vb on form

Help for a newbie pls. I've searched the forum but didn't find any suitable answer.

I’ve created a VB form for use on an Excel 2007 spreadsheet running in compatibility mode.

Amongst other things, I’m data capturing a Surname and the file name of an image already on the hard disk, and writing this to my spreadsheet with loads of other data. This is working fine.

I would now like to add a routine to my save button (which already writes the data to the spreadsheet.) I need it now to create a copy of the file whose name I captured and Append the Surname in front of the existing file name.

So I would data capture

Label Name Data

txtsnam Surname Smith

txtfilenam FileName DSC02345.jpg

I then want a copy of this file created as

Smith_DSC02345.jpg

Working out how to do this is beyond my knowledge & understanding, I can usually work these things out with a few solid hints, but getting the initial start is often beyond me.

My first steps are

 Dim savnam As String
 Dim newsavnam As String


   savnam = ("txtimgno")
   newsavnam = ("txtsname" & "_" & "txtfnam" & "_" & "txtimgno")

   FileCopy "H:\Doc\Test\V1\[savnam].jpg", "H:\Doc\Test\V1\[newsavnam].jpg"

this isn't working right, but its a start

Can anyone help please.

Thanks

Colin

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Strangely enough, I thought I helped you despite the amount of work that you made for me by not actually reading the Forum Rules before agreeing to them.