Saving problem.

[Krondor]

Columns("A:G").Select
Selection.Copy
Workbooks.Add
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("A5").Select
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:="A:\BSUoSDD.csv", FileFormat:=xlCSV, _
CreateBackup:=False
ActiveWorkbook.Close
Sheets("Macro Buttons").Select

In the above macro above it makes a new sheet to copy to and save. But it hangs asking if i want to save the sheet that been created when i want to close it any one know a fix or better way.

Thanks in advance

 

[erik.van.geit]

Hi, Krondor,

WELCOME to the Board! ! !

Make it
ActiveWorkbook.Close Save = True
or just ActiveWorkbook.Close True

kind regards,
Erik

 

[Krondor]

Thanks

 

[Peter van Vliet]

Hi Krondor,

Put
Application.DisplayAlerts = False
at the start of your macro and it will also eliminate similar problems with other code e.g protect

Regards,

Peter

 

[erik.van.geit]

Put
Application.DisplayAlerts = False
at the start of your macro and it will also eliminate similar problems with other code e.g protect

But be careful for the use of this item!
In your code you can delete pages, overwrite files, ... without any warning !!

kind regards,
Erik