Not having much luck with this one so far...
in a module:
In a sub:Code:Public xlOut As Excel.Application
but the damn thing won't close till I quit my app.Code:Set xlOut = CreateObject("Excel.Application") With xlOut .Application.DisplayAlerts = False etc. etc... .ActiveWorkbook.Close SaveChanges:=False End With xlOut.Quit Set xlOut = Nothing
HHHHHHHHHHHHHHEEEEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLPPPPPPPPPPPP!




Reply With Quote