Typing from clipboard

[bruxadosul]

Hello,

I've been having osme trouble to find out how to do it.

I have an excel file with a list of names to put into a library management software. Some of the info the software will not accept the "ctrl v" command (it's a dropbox field). It must be typed.

I have tried using the keypress command, the define string from clipboard and some other tips I've seen here in the forum. They didn't work.

Also, after running a few times, the macro won't play anymore. I must close and open again.

event_log_mmm.txt (6.68 KB)

tes.mmmacro (1.26 KB)

2 | RUN ACTION | SELECT WINDOW BY NAME | Excel
25 | 474 | 1066 | 2488 | Keypress Ctrl+ | c
2 | RUN ACTION | SELECT WINDOW BY NAME | Biblioteca Fácil 8.5.1 [Uso Exclusivo de: Colégio Horácio Ribeiro dos Reis]
8 | 755 | 420 | 50 | Keypress Shift+ | HOME
9 | 755 | 420 | 50 | Keypress delete
10 | 755 | 420 | 50 | Keypress Shift+ | END
11 | 755 | 420 | 50 | Keypress delete
7 | 411 | 1019 | 100 | Keypress Ctrl+ | v
8 | 411 | 1019 | 100 | Keypress enter
8 | 411 | 1019 | 100 | Keypress enter
8 | 411 | 1019 | 100 | Keypress enter
2 | RUN ACTION | SELECT WINDOW BY NAME | Excel
15 | 187 | 275 | 680 | Keypress LEFT
16 | 187 | 275 | 1760 | Keypress Ctrl+ | c
2 | RUN ACTION | SELECT WINDOW BY NAME | Biblioteca Fácil 8.5.1 [Uso Exclusivo de: Colégio Horácio Ribeiro dos Reis]
13 | RUN ACTION | DEFINE STRING VARIABLE | %STRING%::%CLIPBOARD%
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress TAB
18 | 264 | 450 | 50 | Keypress %STRING%

[Steve]

Hi bruxadosul

Your syntax looks ok. So the issue is that your ctrl+v's arnt populating your excel spread sheet. Is that correct?