Search found 4 matches

by MadsSEB
Fri Nov 09, 2018 8:17 am
Forum: Technical / Scripting
Topic: If/else statement on a specific value in Excel
Replies: 5
Views: 4052

Re: If/else statement on a specific value in Excel

Okay, I'll try take a closer look at that link again. The variables, by the way, I got from the If/else advanced expression inside of Macro itself, but I wasn't even sure if that was did right tbh.. But you would suggest me to use XLGetCell in this case? Again, thanks for your time and help. Much ap...
by MadsSEB
Mon Nov 05, 2018 7:53 am
Forum: Technical / Scripting
Topic: If/else statement on a specific value in Excel
Replies: 5
Views: 4052

Re: If/else statement on a specific value in Excel

Hello Marcus - I hope this image explains what im trying to do. This is my code so far: setFocus>Microsoft Excel* wait>0.5 IF>(%DECIDED DD LEVEL IN CAC% = "DD") AND (%CONDITIONS/COMMENTS% = "Reason code should be "CAC decision, not HRI") setFocus>SEB Kort* //do something more ELSE press down //go fo...
by MadsSEB
Mon Nov 05, 2018 7:24 am
Forum: Technical / Scripting
Topic: If/else statement on a specific value in Excel
Replies: 5
Views: 4052

Re: If/else statement on a specific value in Excel

Hey Marcus - thanks for your reply. I'll try again :) And thanks for the links
by MadsSEB
Fri Nov 02, 2018 10:04 am
Forum: Technical / Scripting
Topic: If/else statement on a specific value in Excel
Replies: 5
Views: 4052

If/else statement on a specific value in Excel

Hey So I have a list of companies in a Excel document and I want to "seperate" them in to two categories. "DD" and "EDD". So everytime my macro meets a column with the value "DD" it should //do something and same with "EDD" it should do //something else. How do I do this? What's the syntax for that?...
Sign up to our newsletter for free automation tips, tricks & discounts