View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Getting list of files in a folder to excel

And you have a slightly different response in .misc.


Rishi wrote:

Hello everyone,
I have a folder in C drive called images, this folder has
a number of image files that have been named as follows:
DSCN1234
DSCN1235
DSCN1236...and so on.
Now I have a table in excel that gives me the following
information
Old File New File
DSCN1234 - 98142-2WBOR
DSCN1235 - 98142-2YBOR
DSCN1236 - 98142-2WBOP

Now I want to rename all the file in this c:\images
folder, using the information that I have in the excel
table.
Please help.
Thanx

Rishi


--

Dave Peterson