HI
 Ive created a system which , from access, autmatically opens an
existing excel workbook, carries out some formatting and saves the
file.

When the system is running and the code hits the following line :

XLBook.Close Savechanges:=True, FileName:=FileToOpen

The user is then prompted with 

"The (File Name) already exists, do you want to overwrite it?"

I have tried using SetWarnings but it doesnt seem to help,

Any Ideas,

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.

Try -

XLBook.DisplayAlerts = False





>From: "Tim Maher" <tim.maher@s...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Set Warnings Off
>Date: Wed, 27 Nov 2002 11:37:14 +0000
>
>HI
>  Ive created a system which , from access, autmatically opens an
>existing excel workbook, carries out some formatting and saves the
>file.
>
>When the system is running and the code hits the following line :
>
>XLBook.Close Savechanges:=True, FileName:=FileToOpen
>
>The user is then prompted with
>
>"The (File Name) already exists, do you want to overwrite it?"
>
>I have tried using SetWarnings but it doesnt seem to help,
>
>Any Ideas,
>
>Tim
>This e-mail transmission is strictly confidential and intended solely
>for the person or organisation to who it is addressed.  It may contain
>privileged and confidential information and if you are not the
>intended recipient, you must not copy, distribute or take any action
>in reliance on it.
>If you have received this email in error, please notify us as soon as
>possible and delete it.
>This e-mail has been scanned using Anti-Virus software, however,
>Swansea NHS Trust accept no responsibility for infection caused by
>any virus received on the recipients system.
>
>
>
>


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail

Hi Tim,

The Set Warnings Off command only works in Access.

You are actually in Excel when these error messages occur.

Check the Excel command set to see if there is a save/overwrite/without
warnings option or command.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Tim Maher [mailto:tim.maher@s...]
Sent: Wednesday, November 27, 2002 05:37
To: Access
Subject: [access] Set Warnings Off

HI
 Ive created a system which , from access, autmatically opens an
existing excel workbook, carries out some formatting and saves the
file.

When the system is running and the code hits the following line :

XLBook.Close Savechanges:=3DTrue, FileName:=3DFileToOpen

The user is then prompted with

"The (File Name) already exists, do you want to overwrite it?"

I have tried using SetWarnings but it doesnt seem to help,

Any Ideas,

Tim
This e-mail transmission is strictly confidential and intended solely
for the person or organisation to who it is addressed.  It may contain
privileged and confidential information and if you are not the
intended recipient, you must not copy, distribute or take any action
in reliance on it.
If you have received this email in error, please notify us as soon as
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however,
Swansea NHS Trust accept no responsibility for infection caused by
any virus received on the recipients system.