Help with Excel VBA

[Jon Spragg]

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

[DJP]

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. <your profile>\My Documents).

"Jon Spragg" <jo********@btconnect.com> wrote in message
news:de**********@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

[pellem]

Are you sure Shell has finished executing before checking for the file?

Also, in Excel you can check 'Tools'->'Macro'->'Security'.
This may affect it if if set to high.