Hi Shyam, Please if possible if u can share file in unprotected vba.
thanks & rgds On Mon, Apr 19, 2010 at 10:27 AM, rf1234 rf1234 <rfhyd1...@gmail.com> wrote: > Hello CrazyBond > Actually this was my private project,perhapes that's the reason it > will be locked. > ok if u like this,i will try to send again without any lock.... > > > > > > > > > > > > > On Mon, Apr 19, 2010 at 12:37 AM, crazybond <crazybond...@gmail.com> > wrote: > > hi Shyam, > > > > Can I get the unprotected version of the said macro(Invoice loader with > > Sample Invoice.rar) ? > > > > Regds. > > > > On Thu, Apr 8, 2010 at 10:16 AM, rf1234 rf1234 <rfhyd1...@gmail.com> > wrote: > >> > >> Hello Dear > >> Attached is the macro and sample xls,you can append or import, > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> Hope it Will Help > >> Happy To Help > >> :) > >> Shyam > >> > >> On Tue, Apr 6, 2010 at 10:48 PM, janet dickson <janetdicks...@gmail.com > > > >> wrote: > >> > Hello Team > >> > > >> > I have more than 52 workbooks each contain 3 sheets but only one sheet > >> > "sheet1" contain data. all sheets containing data have the same column > >> > names > >> > in the 1st row, i want to append all sheets into one excel sheet. > >> > Please send me some codes to accomplish the task. > >> > > >> > Thanks in advance > >> > Jenie.. > >> > > >> > -- > >> > > >> > > ---------------------------------------------------------------------------------- > >> > Some important links for excel users: > >> > 1. Follow us on TWITTER for tips tricks and links : > >> > http://twitter.com/exceldailytip > >> > 2. Join our Facebook Group @ > >> > http://www.facebook.com/group.php?gid=287779555678 > >> > 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 > >> > >> > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our Facebook Group @ > >> http://www.facebook.com/group.php?gid=287779555678 > >> 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 > > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > > -- > > ---------------------------------------------------------------------------------- > 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