Quick question

[uznut]

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")

[CyberSlug]

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

See FAQ #9 (also available in the AutoIt help file) for an explanation

[sugi]

$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.

[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

[uznut]

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

[CyberSlug]

Oops, forgot about spaces in the path.... Try something this:

$path = '"' & @ScriptDir & '\master business_' & $00 & '.txt' & '"'

Run(@ComSpec & " /c excel.exe " & $path)

[Guest Guest]

woo hoo it works ty