Deleting a created Excel worksheet in VB...
Terry,
Try "Excel.Application.DisplayAlerts = False", then just
"Excel.Application.Quit" (use whatever object variable you created for the
"Excel.Application"). If I remember correctly, this should close without saving
the worksheet or prompting to save.
Regards,
Eric
Quote:
>I create an excel worksheet within VB so it's easier to print formatted
>data. But when I try to close the excel object, it asks me if I want to save
>the worksheet. I can't seem to find any way to kill the worksheet and not
>have excel ask if I want to save it first...Any ideas?
>Thanks.
