Jump to content
Macro Express Forums

If Variable Statement Not Working


Recommended Posts

What the heck is going on with this? :angry:

I have hundreds of IF Then statements throughout multiple macros but this one is not working right.


<IFVAR2:3:01:1:3.12 ><MACRUN2:Monthly Send Reports From Lotus ><ENDIF>


Which translates to:


IF Variable %D1% = 3.12

Macro Run: Monthly Send Reports From Lotus

End If


Now, how hard is this?

But when %D1% is 3.12 is passes it right by.

I step through the Macro and pull up the Variable Values Window....Yup, %D1% is definitely 3.12, but it still passes by the Macro Run Command.

I tried making it: IF Variable %D1% <> 3.12.... Now it works but the problem is %D1% IS 3.12.

Apparently Macro Express is not see it correctly....

Any Thoughts on this?



Keith :blink:

Link to comment
Share on other sites

Many spreadsheets have hidden data in them that we cannot see. Unfortunately, when we copy information from a spreadsheet, this data is transferred as well. To eliminate the unseen data, you will need to use the Trim option found in the Variable Modify String command to remove the unwanted data. Once you have trimmed the information, you can then convert the value to a decimal variable.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...