code dont read the line

**Kristofferdk** · 06-04-2012, 04:35 AM

hey exp.

i have taken over a macro from another, he is not in the company longer.
the macro reads an ark from excel and then sending it to a program called. host on-demand.

it is the dessinNr. if a number is only in 3 numbers it is to put 0 in front but this function don work, if the is under 5 number it joust stops ..

Please Login or Register  to view this content.

**JBeaucaire** · 06-04-2012, 01:54 PM

I would think you could replace this:

Please Login or Register  to view this content.

With this:

Please Login or Register  to view this content.

**JBeaucaire** · 06-06-2012, 02:03 PM

Thanks for the feedback.

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.

**Kristofferdk** · 06-13-2012, 09:09 AM

hey it seems that this thing keeps on. i was thinking is the a way that i can put 0 in front of numbers in row R. but only if the is under 6 numbers the macro understands. from 6 and op therefore i was thinking, that if the was 0 in front from 6 and down that would be the solution ...

i need some how to make this a part of the macro, so it will works automatically, when they pres play

Please Login or Register  to view this content.

**JBeaucaire** · 06-13-2012, 11:57 AM

I think you mean this:

Please Login or Register  to view this content.

**Kristofferdk** · 06-15-2012, 07:10 AM

hey it solved the problem, but the next one, is that the data that are transfer over. is no incorrect. therefore i was thinking is the a way to put, the 0 ind-front from 5 and down in the excel ark. and then use the original macro ?