Save file from the value of cell in different opened file

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

Elton Law

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
 
It works.
Thanks a lot !

Jacob Skaria said:
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
Click to expand...
 
Back
Top