Web Development

Ask something
Discussion Locked

VB & Excel question

0 helpful
1 reply

by dpick75

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a program that pulls info from excel and inserts to as/400 (screen scraper) but this only does one cell in one colum at a time which is fine for some projects. but what if i want to enter varies items from other columns on a row into the AS/400. Is this possible, can varies columns of a row be specified before moving to the next row?

1 reply

by cmb from omaha

If I understand what you are trying to do, my first suggestion would be to use the concatenate function in Excel. You can combine the data from two or more columns into one =new= column, adding spaces or commas as delimiters if appropriate. Then, have your program "pull" the needed information from that new column.

HTH

This discussion is closed to new replies.