Lots of questions before we can begin: are the different reports in one folder really Excel files? or are they ASCII files created with Excel extensions?
If they're actually excel files, are there multiple sheets in each file? do you want one sheet or all? what version of excel are you using. are there other files in the report folder or can we simply import all files in the folder? Is there any column that ALWAYS has data? (like a record number?) If you search through the group list(s) you'll find people that have techniques for retrieving (and even writing?) data from Excel files without opening them. I've never tried it. I've always opened the file, extracted the data and closed the file. finally... How comfortable are you with VBA? in other words, are you asking us to write the code for you or are you looking for direction? Paul ________________________________ From: Hitesh Dhare <hitesh.dh...@idea.adityabirla.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Fri, April 30, 2010 1:10:55 AM Subject: $$Excel-Macros$$ How to Copy data from different Excel files into a single Excel Sheet in appended way? Hi There, I am looking for a Macro which copies data from different Excels's specific sheet into new Excel by appending the same. These different Excel's are basically a daily report dumped into one folder. Will be thankful to you guys if you can provide the macro. Thanks Hitesh. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe