Thread: How to overwrite a file automaticaly
View Single Post
  #1  
Old January 23rd 08, 10:46 AM posted to microsoft.public.outlook.program_vba
bbnimda
external usenet poster
  
Posts: 94
Default How to overwrite a file automaticaly
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