View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
André André is offline
external usenet poster
 
Posts: 8
Default Saving files based on lookup

Hi,

I have many many files which I want to save in different folders. All files
has a number in C1 and based on that number, I need to do a lookup in a
separate file containing the name of the folder. The file has to saved in
the corresponding folder.

Ex:
File A has number 123 in cell C1
Folder-file looks like this:
Number Foldername
123 Folder A
234 Folder B
etc.
In this example, Folder A is the correct folder, and the file needs to be
moved from the current location to the subfolder "Folder A".
Repeat for all files in top-folder.

I guess this is quite simple to program in VBA ..... if you know how.....

Any help would be most appreciated.

Regards,
André