Hi guys,

I've had a bit of a search around Google and I can't find much info on this.

Basically, I have an Access database with some pretty heavy VB coding. There will be a front-end distributed to a bunch of users.

Part of the functionality of this, is that Access needs to modify an excel sheet, shipped with the front-end application. I have made the distributable front-end require the Access 2007 Runtime, to allow users without Access installed on their machines to use the application.

My problem is that if a user is loading the application with the runtime (no excel installed), the code I have written to modify the contents of the Excel file will fall over.

Are there any libraries, Microsoft supplied or not, that will allow me to modify the contents of an excel file (we're talking basics, Cell A1 = a number) without the user having a copy of Excel installed on their machine.

My problem is that the Excel file is integral, and there is no work around for us.

Thanks in advance,
Brad