read excel data

Trumpet2 · May 8, 2014

I'm using Extra and I have a column of data 1500 +/- records. I want to retrieve the first record place it in the extra session run my application in extra. Then retrieve the next record and so on till finished. Is there a way to do this from extra with VB.

SkipVought · May 8, 2014

Hi,

Do you have 1500 rows ON ONE SCREEN, or something else?

Skip,
_{Just traded in my OLD subtlety...

for a NUance!}

Trumpet2 · May 8, 2014

Skip I have a Excel spreadsheet with 1500 items in column a so I have cell a1 to cell a1500. I have to take each items# and place in a extra application then retrieve that item and close it out. It is very time consuming. I want to write something to automate this act. I can do the macro for the extra application but am having trouble doing the call to excel to retrieve the individual item numbers.

Thanks

SkipVought · May 8, 2014

Since you are using Excel as the data source, AND I'd guess the place to put what you get out of the terminal emulator, I'd code the entire thing in Excel VBA, which is like a Cadillac compared to Extra VB, which is like a Yugo!

Skip,
_{Just traded in my OLD subtlety...

for a NUance!}

SkipVought · May 8, 2014

Anyhow, I assume that you have Set an object variable using the CreateObject("Excel.Application") an then opened the workbook containing your list.

So to loop thru the list in Excel...

Code:

With xl.workbook(1).worksheet(1).cells(1,1).currentregion
   For each r in .range(.cells(1,1), .cells(.rows.count,1))
       'r.value is a value in the list
   Next
End with

Skip,
_{Just traded in my OLD subtlety...

for a NUance!}

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

read excel data

Trumpet2

Technical User

SkipVought

Programmer

Trumpet2

Technical User

SkipVought

Programmer

SkipVought

Programmer

Similar threads

Part and Inventory Search

Sponsor