Error using ADO to Update Excel Spreadsheet

[Andy7777]

Hi,

I am using VB6 to manipulate data in an Excel Spreadsheet. If the Spreadsheet is open in Excel then I can open a Schema to view the fields (column names) OK, but if I try to create a new table (shown as a worksheet) using SQL then I get dumped out of VB with a "..tried to access address 0x000000fdff etc." error message (I don't think this should happen - shouldn't a VB error be generated.) If the spreadsheet is not open via Excel then it works fine.

How can I tell if a spreadsheet is already open? (The Connection object mode property returns adShareDenyNone whether the spreadsheet is already open or not.)

Thanks for your help.

Andy.