Rename a file using cell contents with VBA

[M0J0jojo]

Hi All,

New here and a VBA newb too, I'm tearing my hair out on something that I'm sure has a simple solution.

I'm trying to create a macro to rename a (closed) file in a specific directory and I want to rename it with the contents of a cell in my active workbook.
I've been trying to use the Name and As method.

So I have something like this

Name "C:\Documents\Sample file 1.xlsm" As "C:\Documents\Sample file 2.xlsm"

I just want to rename the file from Sample file 1.xlsm to the contents of Cell A2 on the active workbook.

Any help would be hugely appreciated.

 

[Momentman]

Hi All,

New here and a VBA newb too, I'm tearing my hair out on something that I'm sure has a simple solution.

I'm trying to create a macro to rename a (closed) file in a specific directory and I want to rename it with the contents of a cell in my active workbook.
I've been trying to use the Name and As method.

So I have something like this

Name "C:\Documents\Sample file 1.xlsm" As "C:\Documents\Sample file 2.xlsm"

I just want to rename the file from Sample file 1.xlsm to the contents of Cell A2 on the active workbook.

Any help would be hugely appreciated.

Something like this

Name "C:\Documents\Sample file 1.xlsm" As "C:\Documents\" & ActiveCell.Value & ".xlsm"

'If the name has the extension in cell A2
Name "C:\Documents\Sample file 1.xlsm" As "C:\Documents\" & ActiveCell.Value

 

[M0J0jojo]

Something like this

Name "C:\Documents\Sample file 1.xlsm" As "C:\Documents\" & ActiveCell.Value & ".xlsm"

'If the name has the extension in cell A2
Name "C:\Documents\Sample file 1.xlsm" As "C:\Documents\" & ActiveCell.Value

This worked perfectly, thank you so much

 

[Momentman]

This worked perfectly, thank you so much

You are welcome