Closing a named workbook?

[drucey]

Hi all,

I have a generated filesearch list of files, in a master workbook (FM
Purchase Order.xls).

Is there a macro that i can put in the auto_open bit of the searched
files, to say:

If there is an workbook open called "FM Purchase Order.xls", close it.



Thank you!

 

[Ardus Petus]

Sub test()
On Error Resume Next
Workbooks("FM Purchase Order.xls").Close
On Error GoTo 0
End Sub

HTH

 

[drucey]

Artus, you are amazing.