VBA Shell creating a TXT file

[hsantanna]

Hello guys!

I made a C++ .EXE program that generates in a txt file points of a Fourier series of a given function.
The program is working just fine. It generates the data and I can, manually, import these to excel to create the charts.

Marvelous.

The problem is when I try to automate the process using VBA.

executavel = ActiveWorkbook.path & "\Fourier.exe"
    PID = Shell(executavel, vbNormalFocus)

It works, but when my exe program try to generate the txt file, it simply doesnt. It seems everything is fine, but the file is not generated. I suspect it is something about permission, but I have no clue how to check.

Any idea, guys?

 

[xenou]

Not sure what happens next but if your code is not waiting for the command to finish then you might have problems.
See:
Shell And Wait

In general, sometimes it is necessary to wait for a shell function to finish before you continue on ... (and vba's shell() doesn't do that).