Problem closing a workbook using a macro

[Steve]

The last part of my macro is a save command:

ActiveWorkbook.SaveAs
Filename:="H:\Personal\SIGINCUSTODY.csv", FileFormat _
:=xlCSV, CreateBackup:=False

The file is saved to its required location in csv format.

I then have a command that says ActiveWorkbook.Close,
however, this command will not work automatically. First
of all I get asked the question "Do you want to save the
changes you made to SIGINCUSTODY". After pressing Yes it
asks me to select the location where the file should be
saved. I select the file name as above (to where the file
has already been saved). I then asked do I want to
overwrite the file (as i have already saved it earlier in
the macro) and finally I get asked am I sure that I want
to save in csv format.

Is there anyway of just closing the file without being
asked all these questions ?

Thanks
Steve

 

[Jan Karel Pieterse]

Hi Steve,

Is there anyway of just closing the file without being
asked all these questions ?

Sure:

ActiveWorkbook.Close SaveChanges:=False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Nikos Yannacopoulos]

Steve,

ActiveWorkbook.Close False

will close the workbook without prompting to save - and without saving, but
since you've only just saved, that should be OK.

HTH,
Nikos

 

[Steve]

Thanks Nikos and Jan

-----Original Message-----
Hi Steve,


Sure:

ActiveWorkbook.Close SaveChanges:=False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

.