I have some existing code which takes two cell values and combines them
together to make a file name, saves the document and exits Excel.

Code:
--------------------

ActiveWorkbook.SaveAs Filename:=Sheets("Input").Range("E9").Value & " " & Sheets("Input").Range("E11").Value & ".xls"
If Application.Workbooks.Count = 1 Then
Application.Quit
End If
End Sub
--------------------


Currently the file saves to my local PC, but i would like to save to a
newtwork drive with the following path - "N:\COA Data\"

I have tried to search, but but i'm having trouble expanding my current
code with the dynamic file name to include the network path.
Whenever i edit the "ActiveWorkbook.SaveAs Filename:=Sheets" part of
the code to specify a path i get errors.

Is this at all possible, can anyone help?


--
mcgrad
------------------------------------------------------------------------
mcgrad's Profile: http://www.excelforum.com/member.php...o&userid=30821
View this thread: http://www.excelforum.com/showthread...hreadid=504861