Closing Another Workbook With VBA

Hi all,

I have a piece of VBA that opens up another workbook when the user opens a document (this is due to using INDIRECT formulae). I'd like for this second workbook to also close when the 'parent' workbook is closed. Can anyone suggest a means of doing this?

FYI - the opening VBA is as follows:

Please Login or Register  to view this content.

TIA,

SamuelT

Hi Samuel,

OK, two workbooks (BookA.xls and BookB.xls). When BookA is closed you want to force BookB to close (and save changes, for example)

If you add the following code to ThisWorkbook module in BookA.xls

Please Login or Register  to view this content.

Works for me. No doubt you will need to do some other checking etc.

Hope that helps.

cheers

Malcolm