File Name

[Ronbo]

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.

[Jim Thomlinson]

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

HTH
"Ronbo" wrote:

> 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.