View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drucey[_18_] drucey[_18_] is offline
external usenet poster
 
Posts: 1
Default Closing a named workbook?


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!


--
drucey
------------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=526037