"Concatenate" 2 .xls files

[Samoth]

Hi!

I have 2 Excel Files and I wish to create another Excel File finally. The resultant Excel should contents : first worksheets from first excel and last worksheets from second excel. How can I do that?

Thanks for help!

[MikeS81]

Hi Samoth,

you hage to use ActiveX. What have you done so far and where do you have problems?

Mike

[Samoth]

Hi Mike!

I made an application that inserted into the Sheet2 an array with the Property FormulaArray. I tried to use the Property: WorksheetCopy to copy another Sheet from another .xls file, but no succes. I attached the application to see what I've done.

Thanks! 

[MikeS81]

Hi Samoth,

see this link please

http://forums.ni.com/ni/board/message?board.id=BreakPoint&view=by_date_ascending&message.id=2393#M23...

In the excel.llb you will find an example which shows how to copy a worksheet.

Mike

[Samoth]

Thanks a lot Mike! This is what I was looking for.