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.
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?
Bookmarks