Thread: How to overwrite a file automaticaly
View Single Post
  #3  
Old January 24th 08, 08:37 AM posted to microsoft.public.outlook.program_vba
bbnimda
external usenet poster
  
Posts: 94
Default How to overwrite a file automaticaly
No it doesn't work

"JP" a écrit dans le message de news:
...
Application.DisplayAlerts = False
objExcelApp.ActiveWorkbook.SaveAs "\\Backup\mybackup.xls"
Application.DisplayAlerts = True

or

Kill "\\Backup\mybackup.xls"
objExcelApp.ActiveWorkbook.SaveAs "\\Backup\mybackup.xls"


HTH,
JP

On Jan 23, 4:46 am, "bbnimda" wrote:
Hi all,

I'm using this in outlook script , but if the file exist the system
display
a message and ask me if I want to overwrite it

objExcelApp.ActiveWorkbook.SaveAs \\Backup\mybackup.xls"

is there a way to bypass the message and save the file without displaying
the message ?

Tks

--
Knowlege grows when shared.

http://bensoft.miniville.fr/tra
Ads