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
