vba to close a workbook

[ALPHAKENNYBODY]

Hi,

I have a macro to copy a range of cells from one workbook to another. It starts by checking if the source workbook is open and either opening or activating accordingly.

At the end of the Macro I would like it to close the source workbook if it wasn't already open at the start. Is that possible?

This is the macro:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi, Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[ALPHAKENNYBODY]

Hi, Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Please accept my humblest of apologies this rule has passed me by. I have wrapped it in code.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[ALPHAKENNYBODY]

That has made it close the source file but it closes it all of the time not just when it wasn't initially open??

[Norie]

This part of the code is wrong.

Please Login or Register  to view this content.

You aren't setting Ret to anything.

Also, you can't activate wkbSource as you haven't set it to refer to anything yet.

It should probably look more like this.

Please Login or Register  to view this content.

[ALPHAKENNYBODY]

Still have the same problem.

Also I noticed that everywhere that mentions isworkbookopen just puts the file extension in brackets straight after as you have done. For it to work I have to put an = in between isworkbookopen and the brackets. Otherwise I get Compile error: Sub or Function not defined.

[Norie]

Do you have a function called IsWorkbookOpen?

[ALPHAKENNYBODY]

Errrrrrrr..... I dunno!

[Norie]

Well it's not in the code you posted and it's not a native Excel VBA function.

Try searching the workbook for it, and if you don't find it try searching this forum and others for it or any other function that can be used to find out if a workbook is open.