Save File Using a Range Name

Hi,

I have an open active file and this file contains 2 range names as follows:

1) The name of a 2nd file to open (i.e. FPOF_Root_Directory_Open)
2) The name to save the 2nd open file (i.e. FPOF_Root_Directory_Save)

I tried 2 ways to save the 2nd file, however the method I like to use does not work

Any help is much appreciated, regards john

Please Login or Register  to view this content.

Hi

FPOF_Root_Directory_Open and FPOF_Root_Directory_Save are single cell range names.

FPOF_Root_Directory_Open contains a formula which combines 2 cells and provides the result "C:\Pinnacle-CG\Pinnacle-CG\Financial Projection System 2014\Model\FPOF\FPOF Master.xlsx"

FPOF_Root_Directory_Save contains a formula which combines 2 cells and provides the result "C:\Pinnacle-CG\Pinnacle-CG\Financial Projection System 2014\Model\FPOF\All1_FPOF.xlsx"

Thanks for your help John

Hi

Thanks for your response.

I tried this code and that works.

Please Login or Register  to view this content.

How to replace the workbook name "FP Master.xlsm" with a range name that contains the same?

Seems to me I should be able to reference a cell in thisworkbook which provides the name of the file to save the 2nd file?

Thanks John

Hi,

I am using as name range (This_File_Name) in a cel and that cell contains a formula which produces the file name.

I find it very strange that access to a cell with a formula cannot be valued and the results used?

Thanks John

Thanks for your help.

Unfortunately I was not able to make your suggestion work.

Regards John.