File Name
 

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.xl s""

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

Any help is always apprectiated.

File Name
 

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.xl s""

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

Any help is always apprectiated.