Need Macro to close Excel? 1

[cdove]

Can anyone let me have the code to add to the end of a macro which will automatically close excel?

TIA

Chris

 

[SkipVought]

Hi,

Application.Close

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[CautionMP]

Excel.Application.Quit

If you want to prevent the "Do you want to save changes" dialog you will need to save the workbook first, or set the [tt]Saved[/tt] flag to [tt]True[/tt]

Workbook.Saved = [blue]True[/blue]

Hope this helps,
CMP

Instant programmer, just add coffee.

 

[cdove]

Thanks everyone.

Worked a treat!