Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.lang.visual.basic    |    MS Visual Basic discussions, NOT dot-net    |    10,840 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 9,170 of 10,840    |
|    Steve Gerrard to rolf.michel@styromat.ch    |
|    Re: file save in excel with activex    |
|    25 Jan 05 18:38:38    |
   
   From: mynamehere@comcast.net   
      
   "mic_Design" 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...   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca