Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving files
Hello
Every month i get a output from our system of about 3000 excel files into a folder say c:\output\ the files are number numberically 1.xls 2.xls 3.xls But out of these files i only need about 30, i have a list of these files, and i need to copy them from their current destination to c:\users\bg56\ Is is possible to create a macro, where is i can populate a column say A1:A50 with the file numbers i need 1 2 50 75 55 and have the macro move those files ? I know basic vba but not how to move files, so all help is greatly appreciated. Thanks -- _______________________ Naz, London |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving files
Naz,
Ron DeBruin has a great VBA tutorial on this: http://www.rondebruin.nl/folder.htm#Copy -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Naz" wrote: Hello Every month i get a output from our system of about 3000 excel files into a folder say c:\output\ the files are number numberically 1.xls 2.xls 3.xls But out of these files i only need about 30, i have a list of these files, and i need to copy them from their current destination to c:\users\bg56\ Is is possible to create a macro, where is i can populate a column say A1:A50 with the file numbers i need 1 2 50 75 55 and have the macro move those files ? I know basic vba but not how to move files, so all help is greatly appreciated. Thanks -- _______________________ Naz, London |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving files | Excel Programming | |||
Moving files which are linked | Excel Discussion (Misc queries) | |||
Moving files | Excel Programming | |||
macro as and moving files | Excel Programming | |||
Moving Files | Excel Programming |