View Single Post
  #2 (permalink)  
Old July 11th, 2007, 03:05 AM
Shasur Shasur is offline
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Just Disable the Alerts and proceed.. You will get it

 Application.Sheets(Sheet_Name).Select
     Application.Sheets(Sheet_Name).Copy
Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:=filename1, FileFormat:=xlCSV, _
     CreateBackup:=False
     ActiveWorkbook.Save
     ActiveWindow.Close
     Windows(oldfilename).Activate

Application.DisplayAlerts = True

Cheers
Shasur

http://www.dotnetdud.blogspot.com