Making a VBA Shell Call of a EXE create 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]

Just closing this in order to avoid duplicate posts.
Thread continued at: http://www.mrexcel.com/forum/excel-...sic-applications-shell-creating-txt-file.html