Save to specific dir using a macro

[dezian]

I am trying to save an excel file to a specific directory using the value of a cell as a file name, the using of the cell value works in the code below, but I cant for the life of me get the file to save anywhere but where the original file is saved?

ActiveWorkbook.SaveAs Dir = "S:\WGSpecChemOps\QC Analytical\Facility 2\CERTS\2003", FileName:=ActiveSheet.Range("I7&quot.Value & ".xls"

This is the bit that I can't get to work,

"S:\WGSpecChemOps\QC Analytical\Facility 2\CERTS\2003",

Anyone Help

Cheers Andy

 

[TonyJollans]

Hi dezian,

You're making it more complicated that you need. Just include the path in the filename (there is no Dir parameter) ..

ActiveWorkbook.SaveAs FileName:="S:\WGSpecChemOps\QC Analytical\Facility 2\CERTS\2003\" &  ActiveSheet.Range("I7").Value & ".xls"

Enjoy,
Tony

 

[dezian]

Cheers mate, thanks for your time.

Andy