workbooks.close statement?

[vbacoder]

I'm using the command

workbooks.open filename:= "G:\....."

to open a workbook on my computer. Is there an equivalent statement to close the workbook after I have finished working on it?

Many thanks,

vcoder

 

[Joe4]

I usually use:

ActiveWorkbook.Close

 

[vbacoder]

Thanks jm14!

I tried various things like workbooks.close, but none worked. I'll try this.

vcoder

 

[vbacoder]

I have used the ActiveWorkbook.Close statement, however, in some instances, I am asked (via dialogue prompts) whether I want to save the worksheet and whether I want to keep copied information in the clipboard for later use. I want to answer No, Yes, respectively, but I'm not sure how to invoke this in VB code.

I would be very grateful for any advice on this.

Many thanks,

vcoder

 

[Joe4]

Sorry for the delay in replying, I have been on vacation.

The ActiveWorkbook.Close command has optional arguments, the first of which is whether or not you want to save changes. So if you want to answer "No" to that, it would look like this:

ActiveWorkbook.Close False

Alternatively, you can suppress all warnings by putting this line of code before the other statement:

Application.DisplayAlerts = False

This will suppress all warnings and choose the default. Just be sure to turn it back on afterwards with the command:

Application.DisplayAlerts = True

Regarding the clipboard, I am not sure what the default is. If it is to keep it, they the above will work for that also. You can confirm it either way by testing.

 

[Greg Truby]

Unless you are opening this workbook and pulling stuff out or popping stuff in¹ and the immediately closing it (i.e. if the user gains access to or has the ability to examine the workbook being opened = user can interact with the Excel) then I would shy away from using ActiveWorkbook.

Better to use a global (not tested, just written "off the cuff"):

public g_wbToOpen as workbook
sub foo()
set g_wbtoopen = workbooks.open(filename:="g:\...")
end sub

sub oof()
if not g_wbtoopen is nothing then
   application.displayalerts = false
   g_wbtoopen.close false
   application.displayalerts = true
end if
end sub

<hr />1. "Popping stuff in", of course, doesn't make a lick of sense since you've told us you wish to close this WB w/o saving any changes. But I've seen odder stuff 'round here.