Web Development

General discussion


VB & Excel question

By dpick75 ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by CMB from Omaha In reply to VB & Excel question

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.


Related Discussions

Related Forums