Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy files (column A) to a certain dir
Hello,
This is a simple question but i cant get this to work; In column A i have urls to files (different locations) e:\CALCULATIONS STR. 1\1.xls e:\HEV2\1b.xls e:\CALCULATIONS AABB. 2\1b.xls etc etc I want to copy all these files into a certain dir; Sub COPY() With Sheets("COPY") FileCopy .Range("A1").Value , "U:\Atlas\LOAD_SHEETS\DEX\" End With End Sub This isnt working, could someone help me out? Thanks alot!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy files (column A) to a certain dir
nobody?
The complete paths are in column a and want them to copy to a ceratin dir. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a data from a single column into an array and back into another column? | Excel Programming | |||
Copy table column from multiple word files into excel | Excel Programming | |||
Find specific column titles and copy the column to new workboo | Excel Programming | |||
Save column J only using copy/paste & temporary copy | Excel Programming | |||
copy subfolders, replace text in files and save files in copied subfolders | Excel Programming |