Running Cmd problem

[timpepu]

Hi !
I try to run this and it works ok when I run it by step but otherway comes error and I think that's the reason is time, cmd process name txt to another name and it is not yet ready ! How should it do ?



Do
Do Until txtfile = ""
Call Shell("\\flevy\data\thy\virhetiedostot\tee txttiedosto.cmd", 1)


DoCmd.TransferText acImportFixed, "Viheelliset", "Virheelliset merkinnät", "\\data\thy\virhetiedostot\f338bxxx.txt", False, ""

[pbaldy]

Two thoughts:

http://www.mvps.org/access/api/api0021.htm

http://www.mvps.org/access/api/api0004.htm

[timpepu]

Two thoughts:

http://www.mvps.org/access/api/api0021.htm

http://www.mvps.org/access/api/api0004.htm

Thank you for the answer !

I'm not an expert , how should I put my code for example to case api004

[pbaldy]

I've never needed that myself. Based on the instructions, copy all the code there into a standard module, then use ShellWait instead of Shell.