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
