ABlair
06-21-2001, 06:31 AM
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?
HOW DO I DO THIS?
|
View Full Version : OLE ABlair 06-21-2001, 06:31 AM 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 06-26-2001, 11:12 AM Why would you want to do this? No offense... ElsVanMiert 06-27-2001, 12:54 AM 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. |