Hello - Im having trouble with a save macro... When a user presses the
button i want the file to save itself to a a specific location. The
below is my caode which works apart from it saves to H:\ATMT instead
of G:\2005\ATMT. Can anyone see where im going wrong?

Thanks

Private Sub CommandButton6_Click()
Sheets("Report").Copy
v2 = Sheets("Report").Range("C10").Value
v3 = Sheets("Report").Range("N10").Value
ChDir "G:\2005\ATMT"
ActiveWorkbook.SaveAs Filename:= _
v2 & " " & v3, FileFormat:=xlNormal
End Sub


--
LB79
------------------------------------------------------------------------
LB79's Profile: http://www.excelforum.com/member.php...o&userid=12156
View this thread: http://www.excelforum.com/showthread...hreadid=398632