Hi Paul, There are excel files with different sheet in it. I need to capture details of specific sheet. Also it is nice if the details are collected without opening Excel. I am comfortable with VBA and having working experience on Macros in Excel. I need some basic code so that I can go forward.
Regards, Hitesh. -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of rf1234 rf1234 Sent: Friday, April 30, 2010 5:37 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Copy data from different Excel files into a single Excel Sheet in appended way? Dear Paul Schreiner Your email are very Informative, I like your way to explain. :) On Fri, Apr 30, 2010 at 5:34 PM, rf1234 rf1234 <rfhyd1...@gmail.com> wrote: > Hello Dear, > There are many macro available to import specific range. > I.E > It is possible to select all xls file in 1 folder,and it will apend all in > 1 master sheet. > Last time 1 of my friend ask me for help,and that was, he want to > access.... > 1 invoice number > 2 po number > 3 invoiced value > 4 client > > These should be append in 1 master sheet.Problem was not very easy. > But we got achivement after 2 days.I am attaching the sample macro > with sample invoices. > > You can change code according to requirements. > > :) > > > > > > > > On Fri, Apr 30, 2010 at 5:17 PM, Paul Schreiner <schreiner_p...@att.net> > wrote: >> 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 >> > > > > -- > > Thanks Regards > Shyam > Software Engineer > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > When one door of happiness closes, another opens; > but often we look so long at the closed door that we do not see the > one which has been opened for us. > - Helen Keller > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, > aber oft schauen wir so lange auf die geschlossene Tür, > dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- 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 ************************************************************************ ideacellular.com E-Mail Domain is now idea.adityabirla.com E-Mail Domain ************************************************************************ ****************************************************************************************************** Visit www.ideacellular.com to know more about latest Products, tariffs, online payments and recharges. ****************************************************************************************************** An idea can change your life. ************** LEGAL DISCLAIMER ************ This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at mailad...@idea.adityabirla.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. IDEA Cellular Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail. -- ---------------------------------------------------------------------------------- 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
