read data from 2 excel sheets and write both into 1 excel sheet

[RLemo]

Greetings.  Let me explain this a bit.  I am wondering what would be the best way to go about this.

I have 2 small Excel spreadsheets.  I want to be able to read the first 5 cells in the first row from each spreadsheet.

I then want to write the data from those 2 sheets into a third different spreadsheet starting in different columns.

I do not have the Excel Report set.  I was hoping to do this with active X, but I'm not sure if this can be done.

Thank you,

bob

[MikeS81]

Hi RLemo,
yes it is possible. See this thread for more informations. There is also an example.
http://forums.ni.com/ni/board/message?board.id=170&message.id=329136&query.id=110669#M329136

Hope it helps.
Mike

[smercurio_fc]

You should peruse the Excel thread for lots of examples.