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