Closing a named workbook?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drucey - 24 Mar 2006 11:18 GMT

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!

Signature

drucey

Reply to this Message

Ardus Petus - 24 Mar 2006 11:38 GMT

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

HTH
--
AP

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Thank you!

Reply to this Message

drucey - 24 Mar 2006 11:59 GMT

Artus, you are amazing.

Signature

drucey

Reply to this Message