Create String From Excel Column Follow

0
Avatar
Legacy Poster

I m trying to add multiple fields from the same column of an Excel sheet which contains IMEI numbers and put them on a single label into a PDF417 barcode. I need it to have "vbCrLf" or carriage return and line feed after each column. I've tried a Do While Loop and creating a string and loading it into value but it only seems to get the first value. I'm new at VBScript and could use some expert help. Thank you in advance.

 

Dim strIMEI

Do while value = True

strIMEI = Value & vbCrLf

Loop

Value = strIMEI

3 comments

0
Avatar
Legacy Poster
Comment actions Permalink

I got this to work with different code.

0
Avatar
Legacy Poster
Comment actions Permalink

Would you mind sharing the code that worked for you?

 

Thanks.

0
Avatar
Legacy Poster
Comment actions Permalink

I'd love to see it as well!

Please sign in to leave a comment.