Running a batch file from excel visual basic

[lhkeeper]

Hello everyone,

I have searched a lot in the web for the solution but I cannot find it. The issue is this: I need to open or run a batch or txt file from VB.

The code I have is this:

Sub Example()

Dim RetVal
RutaCompleta = Ruta & "\" & "texto.txt"
RetVal = Shell("C:\BatchFile.txt")

End Sub

But when I execute the code appears a window message with "error '5' in time of execution"...

I don't know what I am doing wrong...

Thanks in advance...

 

[hiker95]

lhkeeper,

See if the following links will help:

http://www.mrexcel.com/forum/excel-...al-basic-applications-running-batch-file.html

http://www.mrexcel.com/forum/excel-questions/662189-running-bat-visual-basic-applications.html


Plus, there is a lot of information on the web if you do a search for Running a batch file from excel vba.

 

[lhkeeper]

Yes, I do know there is a lot of information.

I applied the codes that appears in other solutions but it does not work. It is strange, because I write the path of the windows' calculator and this opens indeed. But I replace the path of the text file and I doesn't open.