Test for blank cell in Excel - Date field

wilfredtr · Post by **wilfredtr** » Thu Aug 14, 2003 4:20 pm

I was using the following code to test for a blank cell and then stop. However it doesn't work in a date field! Can anyone help? This is my first post. -Wilfred

Let>WW_TIMEOUT=5
CapsOff
LABEL>TOP
// This is the beginning of the script
SetFocus>Excel*
Press CTRL
Send>c
Wait>.5
Release CTRL
GCB>WITCB
IF>WITCB.25
Send>WITCB
// This pastes the copied cell into whereever
Wait>0.25
Press Up
Wait>0.25
Press Left
// This repeats the action
GOTO>TOP
LABEL>END

Bob Hansen · Post by **Bob Hansen** » Thu Aug 14, 2003 4:28 pm

Hi Wilfred....................

You wrote:

I was using the following code

That would be very helpful it was included. Can't solve the problem without it ...wanna try again?

Maybe your second post will be of more use?
===============================
(Edited after code was supplied by editing original message).

Thanks, that's much better......watch for solution now....

support · Post by **support** » Thu Aug 14, 2003 5:46 pm

[quote]GCB>WITCB
IF>WITCBWITCB
Length>WITCB,lenWITCB
IF>lenWITCB<1,END
// This tests for the blank cell