Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

EXCEL XLM MACRO

3 views
Skip to first unread message

YOGEN

unread,
Jul 3, 2002, 5:13:16 AM7/3/02
to
Hi there guys

I need assistance in excel to convert an old xlm macro to
vb code that will run in excel xp.. I hope to god there is
someone out there that can help me.
This is what the xlm code looks like....
S
{LET ROI,+SEED}
Q {LET ROI,+ROI+0.1}
{CALC}
{IF NPV<0}{BRANCH \Q}
{LET ROI,+ROI-0.1}
W {LET ROI,+ROI+0.01}
{CALC}
{IF NPV<0}{BRANCH \W}
{LET ROI,+ROI-0.01}
E {LET ROI,+ROI+0.001}
{CALC}
{IF NPV<0}{BRANCH \E}
{LET ROI,+ROI-0.001}
R {LET ROI,+ROI+0.0001}
{CALC}
{IF NPV<0}{BRANCH \R}
{BEEP}

Any feedback will be greatly appreciated.
Thankyou

0 new messages