Executing Autoit code from Excel VBA

[afzalw]

I am restating a topic that was not solved from >here (I am not sure what are the rules of restarting a already discussed topic)

 I am using the following code in VBA to run Autoitcode.au3 file.

Sub RunFileName()
Dim runscript
Dim FileName As String
FileName = ThisWorkbook.Path & "\Autoitcode.au3"

MsgBox (FileName)

runscript = Shell("C:\Program Files (x86)\AutoIt3\AutoIt3_x64.exe " & FileName)

End Sub

 

[jdelaney]

Odd that you would have excel to drive autoit, rather than the other way around.  Like suggested on your other post, add " around the filename:

runscript = Shell('C:Program Files (x86)AutoIt3AutoIt3_x64.exe "' & FileName & '"')
 

Edited June 19, 2013 by jdelaney

[JLogan3o13]

While I believe the only "rule" about re-posting is if your previous post was locked, it begs the question, why would you not just respond to Water's suggestion in your original post, explaining what didn't work for you, rather than starting a whole new thread? As jdelaney has pointed out, the suggestion is exactly the same. If this is not working for you, don't start a second thread, explain what the result is. Help us help you