| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Files to new directory
I have tried various macros to automate the copying of files from one
directory to another but none of them appear to work. I keep getting error messages. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Excel Files to new directory
VBA supports FileCopy statement.
Did you use the FileCopy? FileCopy source, destination msn --------------------------------------------- the best time to plant a tree was twenty years ago. the second best time, is today - Chinese proverb "Ray Clark" wrote: I have tried various macros to automate the copying of files from one directory to another but none of them appear to work. I keep getting error messages. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Excel Files to new directory
See this page Ray
http://www.rondebruin.nl/folder.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ray Clark" wrote in message ... I have tried various macros to automate the copying of files from one directory to another but none of them appear to work. I keep getting error messages. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Excel Files to new directory
Ron,
Thanks for your help managed to get this working. Much appreciated. "Ron de Bruin" wrote: See this page Ray http://www.rondebruin.nl/folder.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ray Clark" wrote in message ... I have tried various macros to automate the copying of files from one directory to another but none of them appear to work. I keep getting error messages. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Directory List of Excel Files | Excel Programming | |||
| Check if directory empty OR no of files in directory. | Excel Programming | |||
| find files and copy to new directory | Excel Programming | |||
| Printing .pdf files from directory from excel | Excel Programming | |||
| Copy range of many files in directory. | Excel Programming | |||
![Ray Clark[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
