Jump to content
Macro Express Forums

logic- program takes anything with 'b' but i want it take anything that has text and stop when it is empty


Recommended Posts



MY program takes anything from an excel sheet that contains a 'B'. I want it take anythign that has text and stop when the clipboard is empty. The follwoing is the logic that is there presently. if you can suggest anything to change it would be appreciated.




<REP3:06:000001:000002:0002:0:01:1><IVAR2:02:01:1><IVAR2:09:01:0><IVAR2:08:01:0><ACTIVATE2:Session><WAITWIN2:000010:000000:Session><MMW2:88,480><TEXTTYPE:m-c<TAB>lsto<TAB>><ACTIVATE2:Microsoft Excel><CLIPC><TVAR2:98:03:><TMVAR2:01:98:00:000:000:><IFOTH2:08:1:B> <_< <IVAR2:02:01:0><ENDIF><CTRLD><TEXTTYPE:<PAGE DOWN>><CTRLU><CLIPP><TEXTTYPE:<ARROW DOWN>><EXITREP>

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...