Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Input Box
- Thread starter braven
- Start date
- Thread starter
- #2
i found in this website.
now i have another issue
USERINPUT = INPUTBOX ('ENTER PERIOD')
how to do F 'FISCAL YR(YEAR(NOW)PER USERINPUT'
i tired
Myscreen.sendkeys("F ")
Myscreen.sendkeys(''FISCAL YR(YEAR(NOW)PER USERINPUT'
)
it gives syntax errror.
now i have another issue
USERINPUT = INPUTBOX ('ENTER PERIOD')
how to do F 'FISCAL YR(YEAR(NOW)PER USERINPUT'
i tired
Myscreen.sendkeys("F ")
Myscreen.sendkeys(''FISCAL YR(YEAR(NOW)PER USERINPUT'
)
it gives syntax errror.
- Thread starter
- #3
please anyone help me the below one
MyScreen.SendKeys("F")
MyScreen.SendKeys("'" + "FISCAL YR"+MyYear + "per" + UserInput + "'")
i need space befwwe Myyear and per and space between per and userinput
userinput = Input("enter period")
Myyear = year(now())
it sends F 'FISCAL YR2009PER09
MyScreen.SendKeys("F")
MyScreen.SendKeys("'" + "FISCAL YR"+MyYear + "per" + UserInput + "'")
i need space befwwe Myyear and per and space between per and userinput
userinput = Input("enter period")
Myyear = year(now())
it sends F 'FISCAL YR2009PER09
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question