Excel to extract value from another software.

[Cubist]

Hi,
I have a licensed software that has cells similar to excel...

For each Zip/ST, there's a corresponding Area Factor. I need to loop through all of the Zip/ST and extract the corresponding Area Factor.

The desired simple output is something like this in Excel...

I've never done this before not sure if this is possible for excel to interact with another software. Thanks.

 

[rlv01]

I have a licensed software that has cells similar to excel...

Usually such software will have an 'export' feature that will allow you to save such data to a .CSV file, or sometimes directly to an .xlsx format file.

I need to loop through all of the Zip/ST and extract the corresponding Area Factor.

Then you open the .CSV file using Excel, and write a VBA macro to loop through the data.