vba program dies

[Peter Kinsman]

I am converting product structures from Excel sheets to Access tables.
There are five workbooks, each for a different part of the company and each
book has six sheets, one of which contains the structures, with products
along the top and components down the side.
The program creates a new Excel.Application, opens each of the WorkBooks in
turn and makes the appropriate WorkSheet Active. It then processes each
column that contains a finished product and adds a record to the Made_From
table when it finds a cell in that column with a formula. I can process the
WorkBooks individually, but when processing them in turn,the program dies
while processing the third WorkBook, taking ccapp and Norton Internet
Security with it. The strangest thing is that if I kill Excel, Access
throws up an Automation error.
I have tried creating the Excel.Application for each WorkBook, but that
gives a runtime error so maybe I would need to call a subroutine five times.
Has anyone any suggestions please?

Many thanks

Peter Kinsman

maybe I should add that this is Office 97