if syntax error
if syntax error
(OP)
could tell me what is the syntax error in the below.
thanks in advance.
if MyScreen.SendKeys("F"CurrentMonthName "<ENTER>")
thanks in advance.
if MyScreen.SendKeys("F"CurrentMonthName "<ENTER>")
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: if syntax error
RE: if syntax error
this is the code i provide here. but when i have messagbox here it is not displaying anything
x = MyScreen.SendKeys("F CurrentMonthName <ENTER>")
MsgBox x
if x then
Call Found
elseif MyScreen.SendKeys("F LastMonthEnd <ENTER>") then
if strEOFerrormsg = "End of data reached" or strEOFerrormsg = "Scroll at maximum " then
Call Endpgm
Else
Call Found
end if
End if
End if
End Sub
RE: if syntax error
CODE
I believe that you want to send F Jan
Yes?
Skip,
Don't let the Diatribe...![[tongue] tongue](https://www.tipmaster.com/images/tongue.gif)
Just traded in my old subtlety...
talk you to death!
for a NUANCE!
RE: if syntax error
thansk Skip
i am trying to have last month
this functionhas given 1
i need to have month MMM ie jan
Month(DateSerial(1, Month(Now), 1)) - 1
how do it do it.
thanks