Execute prompt command with VBA

[Leandroarb]

Hi,

How to execute this command:

for %f in (* .txt) do type "%f" >> output.txt

In this folder:

D:\Desktop\Kami

With VBA?

Is possible?

Thanks in advance!

 

[welshgasman]

I think you would need to write it to a file and then execute it with Shell ?

https://stackoverflow.com/questions/9403341/running-a-batch-file-in-a-given-directory-using-vba

Something like this

Open TestFile For Output As #1 
Print #1 , "Echo Off"
Print #1 , "ECHO Deleting old file"
Print #1 , ""
Print #1 , "ping 1.1.1.1 -n 1 -w 2000"
Print #1 , ""
Print #1 , "Del """ & strKillFile & """"
Print #1 , ""
Print #1 , "ECHO Copying new file"
Print #1 , "Copy /Y """ & strReplFile & """ """ & strKillFile & """"
Print #1 , ""
Print #1 , "CLICK ANY KEY TO RESTART THE ACCESS PROGRAM"
Print #1 , "START /I " & """MSAccess.exe"" " & strRestart
Close #1 
'Exit Sub
' runs the batch file
Shell TestFile

 

[Leandroarb]

Is exactly this!
Thanks!
Sorry for the response delay!