File exist : No Ask for overwrite

[matrixknow]

Hola,

I create files from access to excel. However when the file already exist, he may overwrite it without asking. I wan't to avoid the anoying ask "the file exist, may I overwrite it". Is a docmd.setwarning false enough to fix this ?

 

[Remou]

What code are you using to create the Excel file?

 

[matrixknow]

xlWorkSheet.Cells(iRow, iCol).EntireColumn.AutoFit
            iFld = iFld + 1
         End If

      Next
      iRow = iRow + 1
      rst1.MoveNext
   Loop
   
   xlWorkSheet.PageSetup.Orientation = xlLandscape
   DoCmd.SetWarnings False
   xlWorkBook.SaveAs strOutput
   xlWorkBook.Close

not the way of docmd ...

 

[PHV]

Replace this:
DoCmd.SetWarnings False
with this:
xlWorkBook.Application.DisplayAlerts = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixknow]

thanks PHV, this was a quick and correct answer. It works and I see now that I should use the statements of excel in this case.