Saving Sheet the wont CLOSE using VBA

[Turbo68]

I am working with a script that will save a SHEET from my workbook to a location on my computer but it opens it up also. SO I am trying to get that NOT to open or at the least we I can get that file to close.

Here is where I am at now:

Application.DisplayAlerts = False
ActiveSheet.Select
ActiveSheet.Copy
ActiveSheet.SaveAs Filename:="G:\INV" & Range("L1").Value & " Inv Report.xlsx" OPENS HERE
Workbooks("G:\INV" & Range("L1").Value & " Inv Report.xlsx").Close Wont CLOSE


Application.DisplayAlerts = True

Thanks in advance!

 

[njimack]

Maybe replace the last line with
ActiveWorkbook.Close

 

[Joe4]

Just use:

[COLOR=#333333]Application.DisplayAlerts = False [/COLOR]
[COLOR=#333333]ActiveSheet.Select[/COLOR]
[COLOR=#333333]ActiveSheet.Copy[/COLOR]
[COLOR=#333333]ActiveSheet.SaveAs Filename:="G:\INV" & Range("L1").Value & " Inv Report.xlsx" [/COLOR]
[COLOR=#ff0000]ActiveWorkbook.Close[/COLOR]

[COLOR=#333333]Application.DisplayAlerts = True[/COLOR]

Edit: I am too slow a typist! njimack beat me to it!

 

[Turbo68]

I tried to over-complicate it here... thanks guys!