TYPE TEXT Replaces Clipboard contents? - Macro Recorder

	home	recent topics	recent posts	search	faq

Home » Macro Recorder » TYPE TEXT Replaces Clipboard contents?

Keyboard and mouse recorder - Jitbit Macro Recorder

7/6/2010 4:36:42 PM doug Posts: 2	The intent of my macro: To paste the Clipboard value into an Excel cell that is next to a cell containing a known value (label). Find the label, move to the right, paste the Clipboard. My macro (exe, no mouse allowed) (1) opens the excel xls, (2) does a find (ctrl+f) using TYPE TEXT for the label value, (3) closes the find window (4) executes a right arrow, then (5) executes a paste (ctrl+v). The resulting MR script looks correct. But the value pasted at step 5 is not the Clipboard value but rather the TYPE TEXT string. Any ideas how to paste the Cliboard contents into the currently active Excel cell? Is the TYPE TEXT function replacing the Clipboard contents? Thanks in advance, Doug.
	0 • permalink
7/19/2010 8:39:37 AM muellerm Posts: 1	Yes it looks like "Type Text" function is using the Clipboard. I've tried to type in "ipconfig" in cmd.exe with the "Type Text" but all i got is a ^V. i had to do a "workaround" via "record macro" and type the text manually.
	0 • permalink