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
