how do i enter inputbox like fiscal year and perid
exampleUserInput = InputBox ("FISCAL YR 2009 PER 08 "
but it changes year and period
is it somthing "FISCAL YR (YR) PER (n+1)
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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.