Dear Expert,

I have asked this question before.
Want to save the file name in accordnace to value in cell A1
Activeworkbook.Saves fileName:= Range("A1").Value
But that was supposed to be in same worksheet and file.

Say, if I want to save a file called ABC.XLS to ABC_20090430.XLS via VB
script, the file contains ABC_20090430.XLS is in file OPENFILE.XLS Cell V2
rather than ABC.xls.

So how to fine-tune the VB scripts please ?

Assuming you have ABC.xls and Openfile.xls which are already saved and open
the below code will save ABC.xls as the name mentioned in Sheet1 Range V2 of
Openfile.xls..

Workbooks("ABC.xls").SaveAs FileName:=
Workbooks("Openfile.xls").Sheets("Sheet1").Range(" V2")

Once you try this adjust the below code to suit your requirement

If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Dear Expert,

I have asked this question before.
Want to save the file name in accordnace to value in cell A1
Activeworkbook.Saves fileName:= Range("A1").Value
But that was supposed to be in same worksheet and file.

Say, if I want to save a file called ABC.XLS to ABC_20090430.XLS via VB
script, the file contains ABC_20090430.XLS is in file OPENFILE.XLS Cell V2
rather than ABC.xls.

So how to fine-tune the VB scripts please ?

It works.
Thanks a lot !

"Jacob Skaria" wrote:

Assuming you have ABC.xls and Openfile.xls which are already saved and open
the below code will save ABC.xls as the name mentioned in Sheet1 Range V2 of
Openfile.xls..

Workbooks("ABC.xls").SaveAs FileName:=
Workbooks("Openfile.xls").Sheets("Sheet1").Range(" V2")

Once you try this adjust the below code to suit your requirement

If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Dear Expert,

I have asked this question before.
Want to save the file name in accordnace to value in cell A1
Activeworkbook.Saves fileName:= Range("A1").Value
But that was supposed to be in same worksheet and file.

Say, if I want to save a file called ABC.XLS to ABC_20090430.XLS via VB
script, the file contains ABC_20090430.XLS is in file OPENFILE.XLS Cell V2
rather than ABC.xls.

So how to fine-tune the VB scripts please ?