excel formula form to value

[Mate]

Hello! The problem i am  facing is that when i copy cells with formulas in Excel using Ctrl + C, it treats it as a picture, and when i navigate to the cell using F2 and then copy, it copies the formula. i would like a solution to copy the cell's value to the clipboard so that i can use it in an 'if' statement in a command line. Thanks in advance.

[zeak]

Hi Mate,

The only method I know if doing this so far, is to Ctrl C on the Cell and Ctrl V into notepad, as notepad doesn't allow pictures and will only paste the value.
Then do Ctrl A to select all and Ctrl C or X to copy the value to clipboard as a value.

Cheers,
Zeak

[zeak]

Here is a little bit of code you could put into your main code to help,

1 | X | X | 1000 | Keypress Ctrl+ | c
2 | RUN ACTION | RUN PROGRAM | C:\Windows\System32\notepad.exe
3 | X | X | 1000 | Keypress Ctrl+ | v
4 | X | X | 1000 | Keypress Ctrl+ | a
5 | X | X | 1000 | Keypress Ctrl+ | c
6 | RUN ACTION | KILL PROCESS NAME | notepad

[Mate]

Thank you very much Zeak it is working! Thanks for your help again.