Using Access to minipulate Excel then save and close workbook

[GODZILLA]

Hel;lo i am using this:

DoCmd.SetWarnings False
Workbooks.Open FileName:="R:\do.txt", Origin:=xlWindows
ChDir "C:\Documents and Settings\Mccan1t\Desktop"
ActiveWorkbook.SaveAs FileName:="C:\Documents and Settings\Mccan1t\Desktop\DO.TXT", FileFormat:=xlText, CreateBackup:=False
ActiveWindow.Close

This does work however it prompts you to save the workbook.

docmd.setwarnings = False does not work no does Application.DisplayAlerts = False.

Is there anything else i can use?

The purpose of this is to change unix data in to data the access will understand.

Thanks

 

[chergh]

Try:

ActiveWindow.Close false

 

[GODZILLA]

Try:

ActiveWindow.Close false

Cracking Problem solved.