How can I close a workbook using VBA?

  • Thread starter Thread starter Trevor
  • Start date Start date
T

Trevor

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
 
Workbooks("coll codes.xls").Close True 'False

Use the True parameter if you want changes saved; False otherwise.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

closing another file by code causes failure to run workbook activate event 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Excel 2013 menubar incompatibility? 1
Custom Document Properties in Word documents and Excel workbooks 13
how to open a workbook when application excel is running ? 4
Open and close workbooks 1
Remotely close a workbook 1
Closing multiple workbooks 1

Back
Top