home bbs files messages ]

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