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,671 of 10,840   
   DJP to All   
   Re: Help with Excel VBA   
   25 Aug 05 21:52:02   
   
   From: djp@snotmail.com   
      
   Are you specifying the full path to the text file within your Java code? If   
   not, you might find that the text file is actually being written, but to the   
   Excel default save folder (eg. \My Documents).   
      
   "Jon Spragg"  wrote in message   
   news:dectbt$6bo$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.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