>>>I am importing data from two Excel spreadsheets via automation.
>>>
>>>When importing the spreadsheets separately, all works well.
>>>
>>>However, when I combine the commands into a single program, I get severe stability problems on the second spreadsheet.
>>>
>>>Does anyone have experience with this?
>>>
>>>TIA, Hilmar.
>>
>>Hi Hilmar,
>>
>>Didn't try to do it like that, but do you close the first spreadsheet before you start to import from the second one?
>
>Sorry, I forgot to mention some details. At first, I left the first spreadsheet open. Then, I issued the .Close() command for the workbook. The problems persisted. Finally, I closed Excel itself, manually, before running the second part - but several times, I still got the stability problems. I had to reset the computer several times.
>
>Hilmar.


Is there anything special about second spreadsheet? Will it work the same way if you change the order, i.e import the second spreadsheet first?