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
Bookmarks