Close open workbooks

[John Davis]

Hello All:

Is there a way using Visual Basic that will close all open workbooks simultaneously.

Any help is appreciated.

 

[Colin Legg]

Hi John,

The workbooks collection object has a close method:

Workbooks.Close

 

[John Davis]

Hi John,

The workbooks collection object has a close method:

Workbooks.Close

Thanks for the info Colin.