Hi paul, after opening the userform file, i am getting as runtime error. I am using excel 2007... Chk n tel me the solution to open dat file
On 6/25/10, 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 > -- Sent from my mobile device -- ---------------------------------------------------------------------------------- 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
