file save in excel with activex

[mic_Design]

hello

my vb application fills an excel worksheet with data. i use activex
commands. if i try to save the excel sheet, and the document allready exits,
i get a message box. how can i do the save command without this message box.
the fill and save should work quiet, without any user acitivities.

thank you very mutch for your help.

regards

rolf

[Veign]

Re: file save in excel with activex

Not sure exactly what you mean but if you are using Excel automation you may
want to set the DisplayAlerts property to False against the Excel
Application object....

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center

http://www.veign.com/vrc_main.asp

--

"mic_Design " <rolf.michel@st yromat.ch> wrote in message
news:41f650b1$1 _1@news.bluewin .ch...[color=blue]
> hello
>
> my vb application fills an excel worksheet with data. i use activex
> commands. if i try to save the excel sheet, and the document allready[/color]
exits,[color=blue]
> i get a message box. how can i do the save command without this message[/color]
box.[color=blue]
> the fill and save should work quiet, without any user acitivities.
>
> thank you very mutch for your help.
>
> regards
>
> rolf
>
>[/color]

[Steve Gerrard]

Re: file save in excel with activex


"mic_Design " <rolf.michel@st yromat.ch> wrote in message
news:41f650b1$1 _1@news.bluewin .ch...
| hello
|
| my vb application fills an excel worksheet with data. i use activex
| commands. if i try to save the excel sheet, and the document allready
exits,
| i get a message box. how can i do the save command without this
message box.
| the fill and save should work quiet, without any user acitivities.
|

Just use some VB to check for the file and delete it just before saving:

strPath = "C:\myfile. xls"
If Len(Dir(strPath )) > 0 Then
Kill strPath
End If
' now save...