*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 -- ---------------------------------------------------------------------------------- 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
