View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trevor[_4_] Trevor[_4_] is offline
external usenet poster
 
Posts: 9
Default How can I close a workbook using VBA?

I have a workbook open that contains a macro which needs
to access another workbook. I have added code to open the
workbook and perform the necessary functions, but how do I
then close that workbook while leaving the active one open
to continue with execution? The file I need to open and
subsequently close is called 'coll codes.xls'.

Any help would be appreciated.

Thanks,

Trevor