OLE

[ABlair]

I WANT TO BE ABLE TO OPEN A NEW EXCEL WORKSHEET FOR EACH RECORD AND ALSO CREATE A NEW ONE FOR NEW RECORDS.

HOW DO I DO THIS?

 

[katiekat]

Why would you want to do this? No offense...

 

[ElsVanMiert]

You can "simply" use the EXCEL object model and control EXCEL remotedly from within ACCESS.
You can even store the spreadsheets inside the ACCESS table structure. I recently wrote a application for a consultant company in which stores up to 50 spreadsheets inside the "tblClients" table.