View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Moving Files from one folder to another using ranges

Hi Dominique

Try

Sub Move_Rename_One_File()
'You can change the path and file name
Name "C:\Users\Ron\SourceFolder\Test.xls" As "C:\Users\Ron\DestFolder\TestNew.xls"
End Sub

You can use a cell reference instead of the path/file names

You can create a loop to do all the cells in the range
If you need help with that post back


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Dominique Feteau" wrote in message ...
I have two lists. Column A has a file path and Column B has a new file
path. I want the file in Column A to be moved to the path in Column B. For
example:

Column A Column B
C:\Path1\file.tif C:\Path2\file.tif

Everything I've searched for just goes to one specific folder. Anyone have
any suggestions on how to do this?

Niq