This is one of the things I enjoy about participating in this group! Nearly a year ago, someone asked about something similar. (It may have been in a different group, I'm in several)
Well.. I had something CLOSE, but it wasn't dynamic. That is, it couldn't "grow". And... they were asking for it to be populated with worksheet names. so, I investigated, and learned how to add checkboxes and name them "as-required". So... modifying my code to fit THEIR requirements the first time took a couple of hours... but then it became a tool in my "arsenal". in fact, I incorporated it into one of my applications (my co-workers were impressed!) then, when your question popped up... again.. I had something CLOSE... I just had to merge in some other tools from my arsenal and there you have it... in just a few minutes! '--------------------------------------------------------------------------- hopefully, you recognized where I defined the source and destination folders. You could modify this to read from cells in your spreadsheet, and even have it make the destination folder if it doesn't exist! good luck.. Paul ________________________________ From: Donna Feauto <[email protected]> To: [email protected] Sent: Fri, June 25, 2010 9:28:24 AM Subject: Re: $$Excel-Macros$$ Select files via checkboxes, then copy those files to a new directory Paul, this is GENIUS! You have saved me. This is absolutely 100% exactly what I need - and it works perfectly. Thank you SO MUCH! Leigh On Fri, Jun 25, 2010 at 8:12 AM, Paul Schreiner <[email protected]> wrote: I did not test it EXTENSIVELY, especially the width of the panel. > >but it should give you something to work with. > >Paul > > > > ________________________________ From: Paul Schreiner <[email protected]> > >To: [email protected] >Sent: Fri, June 25, 2010 8:15:03 AM > >Subject: Re: $$Excel-Macros$$ Select files via checkboxes, then copy those >files to a new directory > > > >I'll throw something together and send it this morning. > >Paul > > > > ________________________________ From: Donna Feauto <[email protected]> >To: [email protected] >Sent: Thu, June 24, 2010 3:01:22 PM >Subject: Re: $$Excel-Macros$$ Select files via checkboxes, then copy those >files to a new directory > >Thank you for the quick reply! > >All in one column would be most beneficial, because some of these filenames >are very long. An example: Nevada Individual Self-Insurance Renewal >Application for Excess Workers' Compensation Coverage.xls > >The number of files can change as new ones are added and old ones are removed, >which may happen a few times a year. The names of the files themselves won't >likely change, but as I mentioned, new ones can be added and dated ones >removed, a few times per year. > >Leigh > > > >On Thu, Jun 24, 2010 at 12:18 PM, Paul Schreiner <[email protected]> >wrote: > >are the file names fixed? or are they different from one day to the next? >> >>what about the number of files? always 25? >> >>how do you want them presented? >>5 rows of 5 columns? >> >>I have a couple of userforms that might work for you. >> >>Paul >> >> >> ________________________________ From: Leigh <[email protected]> >>To: MS EXCEL AND VBA MACROS <[email protected]> >>Sent: Thu, June 24, 2010 10:18:30 AM >>Subject: $$Excel-Macros$$ Select files via checkboxes, then copy those files >>to a new directory >> >> >>I am trying to accomplish this in Excel using VBA, and keep hitting >>brick walls: >> >>I would like to create a user form in Excel with checkboxes for 25 >>different files that exist in a source directory. I would like the >>user to be able to check off the files that they want to copy, and >>then move those files to a new temp directory by clicking a command >>button. >> >>After that, I will use another command button to kick off an email, >>attaching all of the files in that temp directory to the email. >> >>The email part is working. The piece that I keep scrapping and >>starting over is the ability to select those files via checkboxes. >> >>Does anyone have any suggestions or samples that may help with what I >>am trying to do? >> >>Thanks in advance for any advice! >> >>-- >>---------------------------------------------------------------------------------- >>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 [email protected] >> >><><><><><><><><><><><><><><><><><><><><><><> >>HELP US GROW !! >> >>We reach over 7000 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 [email protected] >> >><><><><><><><><><><><><><><><><><><><><><><> >>HELP US GROW !! >> >>We reach over 7000 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 [email protected] > ><><><><><><><><><><><><><><><><><><><><><><> >HELP US GROW !! > >We reach over 7000 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 [email protected] > ><><><><><><><><><><><><><><><><><><><><><><> >HELP US GROW !! > >We reach over 7000 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 [email protected] > ><><><><><><><><><><><><><><><><><><><><><><> >HELP US GROW !! > >We reach over 7000 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
