Posted by Richard S on November 15, 2001 1:47 PM
I have a Macro which has a call shell command which runs a BAT file. The BAT file runs a bit of ftp script to pull a text file from a Unix box to the LAN. This file is then opened in Excel and parsed and named and other stuff. I have a wait command in the macro immediately after the call shell command to give it time to do the imports etc.
At the moment, this is all working fine from my workstation using Excel 2000. However, when another user runs the macro from their workstation using Excel 98, it pulls the existing version of the file from the LAN. It seems to skip the call shell part of the routine. Is there a difference re VBA between the two versions of Excel causing this? Any help appreciated.