Export each record to workbook 1

[mcginty]

Hi All,

I would like to export all individual records in a table to an Excel work for each record, eg.

Record1 -> Book1.xls
Record2 -> Book2.xls
etc..

Any suggestions?

Thanks,
Ted

 

[nerd1003]

Would the cut&copy method be sufficent?

 

[mcginty]

What is cut© ? Do you mean copy & paste? If so no.

If I have 10 records in a table, I need 10 excel workbooks, one for each record with the information inserted.

Rgds,
Ted

 

[nerd1003]

Yes that was the method that I was referring to but the keys must of stuck or somthing. Can't you just copy the info and paste it into a new wkbook?

 

[mcginty]

Unfortunately there would be too many records to do this. I really need it automated.