Originally Posted by
gr8one68
I'm new to the forum. I want to do a "save as" using the value in a cell and save it to a folder on our server. The folder will be variable. I have searched and found and modified a macro that will save the file as I want. I can't find how to tell it to navagate to the folder that I want. Here is the macro that I have to save the file from cell M6 plus a description.
Option Explicit
Sub SaveAsOpportunityNumber()
'Saves filename as value of m6
Dim newFile As String, fName As String
fName = Range("M6").Value
newFile = fName & "-Air Flow"
ActiveWorkbook.SaveAs Filename:=newFile
End Sub
Thanks in advance and I apologize if this has been covered before, I couldn't find it if it was.