Jump to content
Macro Express Forums

Variable to Capture Selection - Not Line


Recommended Posts

If I want to capture a Line I basically do the following:

 

Variable Set to ASCII Char 13 to %CR%

Variable Set to ASCII Char 10 to %LF%

Variable Set String %Content% from the clipboard contents

Split String "%Content%" on "%CR%%LF%" into %Line%, starting at 1

// Place values from SelectPhone into Excel

Window Activate: Microsoft Excel

Text Type (Simulate Keystrokes): %Line[1]%

Text Type (Simulate Keystrokes): <TAB>%Line[2]%

 

At times I only want to capture a part of a line as example: Phone: 262-353-3278

My Selection is made by: Ctrl+Shift(RightArrow), (RightArrow)(RightArrow), Shift (End)

It seems to me I only need to change one line to do this: Text Type (Simulate Keystrokes): <TAB>%Line[2]%

 

The following changes nothing. I still do get the entire Phone Line capture. I onlt want the number.

Text Type (Simulate Keystrokes): <CTRLD><SHIFTD><ARROW RIGHT><CTRLU><SHIFTU><ARROW RIGHT><SHIFT><END><TAB>%Line[11]%

 

Bob

Link to comment
Share on other sites

FYI all of the emails I send to you are being bounced. I also sent you a PM and left a voice mail. I figured I'd try this as a last chance to get thru to you.

 

 

Link to comment
Share on other sites

Join the conversation

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

Guest
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.

Loading...
×
×
  • Create New...