How to close a workbook which contains the macro that's just been run?

[dead_girl]

Hello~

I would like to be able to include a section of code in my macro to b
able to close the workbook in which the macro resides

I've tried the below section of code (in red):

Sub ReplaceNames()
<MY CODE>
. . .

'Select a workbook to make active
Workbooks("Replace_All Names.xls").Activate
'Close active workbook
ActiveWorkbook.Close

End Sub

Note: the workbook which contains this macro is called "Replace_Al
Names.xls"

but this brings up the followng error message window:
"Microsoft Excel cannot find matching data to replace. No cell in th
selection contains what you typed, or no records match the criteria"

Are there any other alternatives??

:

 

[Guest]

Dearly Departed,

It sounds like the error message you're getting isn't from the Close
statement, but from another statement in your code. Try stepping through the
code and I'm pretty sure you'll find the error is elsewhere.

HTH,
Ryan