Vba Change File Name

[ltworf]

I have a file that gets created. Onces it's created I need the file name to changed in vba.
Any suggestions would be appreciated.
Thx

[Mavyak]

Can you show the code that creates the file?

[ltworf]

I found a way. I'm using the Name code ine vba:

FileName = "c:\temp\Ottawa_Rep.csv"
NewFileName = "c:\temp\Ottawa_RepExportCVIDP" & skill & ".csv"
Name FileName As NewFileName

[Mavyak]

Please ensure code tags are placed around any code.

I don't understand the code but if it works, great! Thanks for posting your solution.