closing a workbook with a macro

's Computer Specifications

From a Macro, I have

Set wb1 = ActiveWorkbook
On Error Resume Next
Set wb2 = Workbooks("library.xls")
If wb2 Is Nothing Then
Set wb2 = Workbooks.Open("c:\My Documents\_MapForm\library.xls")
End If

before exiting the macro, is there a way I can close the workbook
"library.xls"???

's Computer Specifications

wb2.close savechanges:=false 'or true

Fan924 wrote:
>
> From a Macro, I have
>
> Set wb1 = ActiveWorkbook
> On Error Resume Next
> Set wb2 = Workbooks("library.xls")
> If wb2 Is Nothing Then
> Set wb2 = Workbooks.Open("c:\My Documents\_MapForm\library.xls")
> End If
>
> before exiting the macro, is there a way I can close the workbook
> "library.xls"???

--

Dave Peterson

's Computer Specifications

> wb2.close savechanges:=false 'or true

Thanks again Dave

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Set macro to run automatically when closing workbook?	=?Utf-8?B?V3VkZHVz?=	Microsoft Excel Misc	9	8th Nov 2008 08:33 AM
Closing a workbook from a macro doesn't close the workbook	=?Utf-8?B?RGF2ZSBQ?=	Microsoft Excel Programming	2	10th Jul 2007 06:16 PM
Problem with closing workbook in macro	=?Utf-8?B?c2xt?=	Microsoft Excel Programming	1	11th Jun 2005 01:23 AM
Problem closing a workbook using a macro	Steve	Microsoft Excel Programming	3	21st Sep 2004 01:03 PM
Re: Macro to run when closing off workbook ...	Bob Phillips	Microsoft Excel Misc	1	15th Jul 2003 10:16 AM