hi
i need some help
i have to copy a sheet from my working excel file and paste it in new file and thn save the file as csv (Comma Delimited) file..
while doing so,even though i m saving the file, i m once again prompted by the message "that do you want to save the changes you made.." whereby i have to click yes...

can this be done thru macro directly????????

the code i have written is as under:
where,
Sheet_Name is the shhet i want to paste
filename1 is the name by which i want to save the new file
oldfilename is the existing excel file where the macro is to b written

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

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