View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Simpson Jim Simpson is offline
external usenet poster
 
Posts: 21
Default Excel 2000 Macro and Perl problem

In Win98 I have an Excel 2000 macro which does some things to "myFile" and
then uses the command "Shell" to call a Batch routine which calls a Perl
script ("gtst.pl") which does some more things to "myFile". When "gtst.pl"
is finished I want to return to the Macro and printout the final "myFile".
But the Macro continues to run after calling "gtst.pl" and finishes long
before "gtst.pl" has completed work on "myFile".

I'm tried everything I can think of with no success. There must be a way to
do this. I hope someone has solved it.

Please help.

Jim