Save to specific dir

[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

 

[QLearnerNow]

what if you just say

dim FileName
FileName = ActiveSheet.Range("I7&quot.Value & ".xls"

ActiveWorkbook.SaveAs "S:/WGSpecChemOps/QC Analytical/Facility 2/CERTS/2003/" & FileName


I have never done excel programming so please forgive me if it doesnt work

Regards,
QLearnerNow