Search the Community
Showing results for tags 'space in folder name'.
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