end the macro in excel clipboard

[hunguy]

Hi guys i have a little bit of problem again. I would like to finish my macro with an IF condition

1 | X | X | 500 | Keypress Ctrl+ | c
2 | IF | CLIPBOARD | VALUE | TEXT IS | | STOP | AND | 2 | RUN ACTION | MESSAGE PROMPT | Mission Completed , nothing left.::End::0::OK


3 | X | X | 500 | Keypress Alt+ | tab


4 | X | X | 500 | Keypress Ctrl+ | v

It is a little part of my macro what i want to do is the macro stop when the clipboard is empty but whit this condition it can not make difference between empty and full cells.

I saw an option about go to the cell with F2 Ctrl Home and so on but my cells values got from equation form so this is not an option for me.

And I also saw the notepad option but that will make very difficult my work , there is not any option to solve this?

[zeak]

Hi Hunguy,

As of current, the notepad method is the most reliable way I know of interacting with Excel.
Steve does have in the works and on his list some improvements of string handling.

See: minimousemacro.proboards.com/thread/608/update-8-4-1-development

Cheers,
Zeak

[philranger]

Hello,

I had similar issues with copies from Excel. I first pre-fill the clipboard with a known value, go in Excel, F2, ctrl-a, ctrl-c, check against my known value because copying something empty just keeps whatever already was in the clipboard.