By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,804 Members | 1,528 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,804 IT Pros & Developers. It's quick & easy.

file save in excel with activex

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <ro*********@styromat.ch> wrote in message
news:41**********@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.

thank you very mutch for your help.

regards

rolf

Jul 17 '05 #2

P: n/a

"mic_Design" <ro*********@styromat.ch> wrote in message
news:41**********@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...
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.