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,667 of 10,840   
   Jon Spragg to All   
   Help with Excel VBA   
   22 Aug 05 16:09:33   
   
   From: jon.spragg@btconnect.com   
      
   Hi,   
      
   I am running an Excel Application that uses a Control Button to invoke a   
   java application that performs some computation and writes the results to a   
   text file.   The VB code behind the Button calls the VB procedure Shell() to   
   invoke the java application.  The problem is, when the java application is   
   run from Excel/VBA the file doesn't get written.  This is not the case   
   when the java application is invoked from either JBuilder or a Command   
   Prompt Window.  Does Excel/VBA block the writing of files while running, or   
   is this a memory thing?   Any insights would be welcome?  The irritating   
   thing is that java doesn't throw any exceptions, the file just doesn't get   
   written.   
      
   Regards,   
      
   \ jon   
      
   --- 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