Jump to content

Recommended Posts

Hey i need to make autoit open a txt file in excel and also they file changes all the time so i tryed to make an input box but when i put the $00= whatever i gave me errors when excel opens. it says master business_$00 does not exsit

$00 = InputBox("FENCIN", "Please type in the correct file number", "", "", -1, -1, 441, 291)
Run(@ComSpec & " /c excel.exe " & @ScriptDir & "\master business_$00.txt")
Sleep("5000")
Send("!fa")
Send("Fincenb")
Send("{TAB}")
Send("c")
Link to post
Share on other sites

$00 = " and this is the variable"
MsgBox(4096, "How to join strings", "Just a demonstration on how to join strings: This is the text" & $00 & ". Followed by another sentence.")

Adjust your Run() command as above.

Link to post
Share on other sites
Guest Guest

Run(@ComSpec & " /c excel.exe " & @ScriptDir & "\master business_ "& $00 &".txt")
i got it to read the $00 but it splits them up i tries to open master.txt then business_.txt then the $00.txt. im gettin confused

Link to post
Share on other sites

Run(@ComSpec & " /c excel.exe " & @ScriptDir & "\master business_ "& $00 &".txt")

i got it to read the $00 but it splits them up i tries to open master.txt then business_.txt then the $00.txt. im gettin confused. oops forgot to login
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
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...