cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

WRITEEXCEL problem in IF statement

Raiko
16-Pearl

WRITEEXCEL problem in IF statement

Hello folks,

I tried to write a routine that stores intermediate results only when I invoke it. For this purpose I'm using a list box that gives out a command variable (out) so that only the parts of the routine are executed that comply with this value. The subsequent routine has either to write or read to a given file data. All works fine and swell except that the first if condition is evaluated when I'm choosing the second one.

The file (MathCad 15 on a Win / 64 Bit machine) is added.

Can somebody spot the error?

Thanks in advance

Raiko

1 ACCEPTED SOLUTION

Accepted Solutions
AndyWesterman
4-Participant
(To:Raiko)

Hi Raiko,

in case out=2 you can get to the WriteExcel ( Z... statement without defining Z & I think that this is what mathcad is complaining about.

regards

Andy

View solution in original post

2 REPLIES 2
AndyWesterman
4-Participant
(To:Raiko)

Hi Raiko,

in case out=2 you can get to the WriteExcel ( Z... statement without defining Z & I think that this is what mathcad is complaining about.

regards

Andy

Hello Andy,

the Z..statement was indeed misplaced. That did the trick

Thanks

Raiko

Top Tags