Hi, Am not familiar with access and it would be great if I get macro or vba script to do the below task. Or please explain me in detail.
Thanks in Advance, Sharma On Mon, Aug 30, 2010 at 2:32 PM, adel elshafe <adel.elsh...@og.com.eg>wrote: > *Dear Sharma > I have small idea but its may be help you > use in access refrence Microsoft scripting runtime > it makes you copy files , create folders > any things related files if you fail send i have already form access* > > > On Mon, Aug 30, 2010 at 10:06 AM, amrahs k <amrahs...@gmail.com> wrote: > >> Dear Experts, >> >> I have a problem to work on a folder where in I need to do manually to do >> the below task. >> >> I have a folder named as "Calibration" in "C:" drive. It contains 500 >> excel files. What I want to do is to create new folder1 and move 50 files to >> it. Then another 50 files to new folder2 till the folder gets empty (i.e) >> all the files moved to new folder. >> >> Can we do it using VBA. >> >> Please suggest me to solve this issue. >> >> Regards, >> Sharma >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> 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 >> > > > > -- > *Thank you and best regards,* > > *Adel Elshafe'y* > *HRIS > Delta Electrical Appliances - IDEAL > Olympic Group* > > *Address : 10th of Ramadan City, 3rd Industrial Zone, # 132 and 133 > Mobile : 012 4331505 > Tel. : 015 - 411531 / 390290 ext. 012 > Fax : 015 - 390200 * > Email : adel.elsh...@gmail.com.eg > Web : www.OlympicGroup.com <http://www.olympicgroup.com/> > > -- > > ---------------------------------------------------------------------------------- > 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 excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> 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