I have a macro file that opens a raw data file located in an input folder on a shared drive, does some fancy macro stuf, then saves that same file out to an output folder (different location) on the shared drive. I dont not want to save or make any changes to the original macro and raw data file, only save changes to the file that is saved in the output folder. Im trying to use the macro to close only the macro and associated files and to leave any unrelated excel files open. The code below closes eveything in excel but saves everything as needed. Thoughts?


Sub Closefiles
'save file with date and time stamp
    Application.DisplayAlerts = False
    With ActiveWorkbook
        .SaveAs Filename:="\\Omaw2kfile02\Company\Cust_Serv\MASTII\TSC\TLC Data Convert\Output\TSC Converted File " & _
        Format(Now, "mmddyy hhmm") & ".xls", Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
        CreateBackup:=False, FileFormat:=56
    .Close False
    End With
    Application.DisplayAlerts = True
    Workbooks.Close

End Sub