> Hi,
> I've got the following code which populates an Excel spreadsheet. The
> problem is that Excel stays in memory and hangs my machine.
> Q199219 was recently offered as a solution, but does not solve my
> problem as I'm not using the 'with' construct.
> Can anyone help ?
> thanks,
> Graham

> snipped code:
> Set xls = New Excel.Application
> xls.Visible = True
> Set wkb = xls.Workbooks.Open(strFilePath & strOutputFile)
> xls.Sheets("TitleSheet").Select
> xls.Range("A1").Select
> wkb.Save
> wkb.Close
> xls.Quit
> Set wkb = Nothing
> Set xls = Nothing

> Sent via Deja.com http://www.deja.com/
> Before you buy.