Jack in the UK
Well-known Member
- Joined
- Feb 16, 2002
- Messages
- 3,215
Hi guys
A little project will be if i have say 250 to 1000 wkbks i need code to rip but row 1 from each into a report documents.
All the data will be lined up ok, ill make sure but the file names will be all sorts, no error check needeed just rip it over and return the data one under the other in the report document
Any ideas of a cleaver way guys
Many thanks in advance!
PS all will be in the same directory not scattered so locational issues are all taken care of and maintance all thats fine, just need from button on XLT to rip the XLS x 250+ over and add to the bottom
A little project will be if i have say 250 to 1000 wkbks i need code to rip but row 1 from each into a report documents.
All the data will be lined up ok, ill make sure but the file names will be all sorts, no error check needeed just rip it over and return the data one under the other in the report document
Any ideas of a cleaver way guys
Many thanks in advance!
PS all will be in the same directory not scattered so locational issues are all taken care of and maintance all thats fine, just need from button on XLT to rip the XLS x 250+ over and add to the bottom