Jump to content
Sign in to follow this  
afzalw

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

Recommended Posts

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 by afzalw

Share this post


Link to post
Share on other sites
water

Put quotes around the filename.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • DynamicRookie
      By DynamicRookie
      Hey There!
       
      So, what i need to do is an app that can read text in a image (I.e. a png that has text saying "This is a png" and return the text to a variable)
      I'm pretty much a newbie on AutoIt, my purpose is doing that but i don't know any function that can

      Any help is much appreciated
    • santoshM
      By santoshM
      How can i exit from a procedure in auto
      Func test() if x=o then     return endif endFunc  
    • Valnurat
      By Valnurat
      Hi
      Small question.
      I trying to find all index in an array with value higher than 7.
      How can that be possible?
    • TrashBoat
      By TrashBoat
      Could someone help me create or give an idea of how to do a incrementing for loop that would do this: https://i.imgur.com/YFUt47H.gifv
      I'm having a hard time figuring it out :S
    • msd1994
      By msd1994
      I have a script that just adds some keyboard shortcuts for things like displaying the current song and artist, moving the window to the side so it won't pop up in my way, and play/pause, next song, previous song (these are the only 3 to still work since they don't need the window handle.)
      In some update recently, Spotify's window class swapped from "[CLASS:SpotifyMainWindow]" to "[CLASS:Chrome_WidgetWin_0]". Using the new class in my controls doesn't seem to work, I've tried getting the window handle from the process handle (_GetHwndFromPID($PID)) but that seems to fail as well.
      Does anybody have some idea of a way I could get this script working again?
       
      edit: seems like discord has the same window class name, so could be some issue with this? Still not sure of a way to solve the issue though, I added a function to get the handle of the active window and can just use that now, but it was able to find it on its own before on spotify startup or script startup which would be preferred.
       
      Thanks!
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.