[AccessD] Preventing user prompts from Excel

Gustav Brock gustav at cactus.dk
Wed Jul 14 09:44:22 CDT 2004


Hi John

Try with the specific file format:

        .SaveAs FileName:=strPathFileName, FileFormat:=xlExcel5, _
          Password:="", WriteResPassword:="", _
          ReadOnlyRecommended:=False, CreateBackup:=False
        .Close

In addition to this you may need to set Application.DisplayAlerts to False as
well.

This works for me.

/gustav


>>try xlApp.ActiveWorkbook.SaveAs Filename:=atrFileName, FileFormat:=xlNormal
> before you close

> I get a compile error on xlNormal




More information about the AccessD mailing list