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>")
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
Computer / IT professional?
Join Tek-Tips Forums!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts - Keyword Search
- One-Click Access To Your
Favorite Forums - Automated Signatures
On Your Posts - Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Talk To Other Members
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...
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