File Name

[Guest]

I am trying to copy a workbook in a dir to another dir. The workbook I am
trying to copy is not the Active Workbook. I get this to work with a fixed
name, but I need the name to change each time to the name in Cell (M9) of the
Active Workbook.

Code:
FileCopy ActiveCell, "C:\Path\Dir\"ActiveSheet.Range("M9").Value.xls""

My problem is adding the cell M9 to the path. What am I doing wrong.

Any help is always apprectiated.

 

[Guest]

FileCopy ActiveCell, "C:\Path\Dir\" & ActiveSheet.Range("M9").Value & ".xls"

HTH