Executing Autoit code from Excel VBA: Space in Folder Name of Path

[afzalw]

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

The Autoit code I want to run, works fine when I directly run by double clicking the file in folder, but when I use this VBA code it gives me error of Autoit

Line 0 Error ("File: E:\Data\Point")

Error : Error Opening the file

Actually this line should be reading this path:

E:\Data\Point Data\Folder\Folder\My File.xlsm

So, executing Autoit code from VBA is not reading the SPACE in between the folder name Point Data and hence not reading the full path. Otherwise running directly by clinking the autoit file its running smoothly.

So is there a way I can run my Autoitcode from VBA without this unreadable space in folder names problem.

Thankyou

Edited April 22, 2013 by afzalw

[water]

Put quotes around the filename.