Macro to see 0 as Blank

[RobP614]

Hello,

I have a semi-complex macro file devloped for a function or our AS/400 system.

I have been asked to modify the macro the run a field as a blank, which I never planned for in my orginal design and now I can't figure out how to had it in...

I'm going to provide the primary file so that someone can maybe take a look and give me an idea.

The main tab titled Lean% references over to the macro tabs titled Macro Static and Macro Flow. (Colum C is my main reference point)

For example line 59 in the Macro Static tab is set to ref ='Lean %''s'!$C$16 if the ref turns out to me a 0 I need it to leave a blank, and just going on to the next line in the macro.

Thanks,
Rob

[tony h]

This is for the formula in C16 on sheet lean%

="autECLSession.autECLPS.SendKeys " & CHAR(34) & IF(B16=0,"",TEXT(100*B16, "00")) & CHAR(34)

But you could use the IF(...) in a variety of places.

This will send the equivalent of a <ENTER> key

[RobP614]

Is there a way to have it send a <Tab> command?

<Enter> creates an error....

[tony h]

CHAR(9) is tab

[RobP614]

How does that fit into the formula...I'm not good with if statements!

Thanks for the help!
Rob

[RobP614]

I got it!

Thanks,
Rob