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
